MD_VERSION
MotherDuck exposes MD_VERSION both as a scalar function and as a pragma.
Use the scalar function when you only need the version string. Use the pragma when you also want the extension hash.
Syntax
SELECT md_version();
PRAGMA md_version;
Output
SELECT md_version(); returns a single VARCHAR value.
PRAGMA md_version; returns:
| Column Name | Data Type | Value |
|---|---|---|
md_extension_version | VARCHAR | Loaded MotherDuck extension version |
md_extension_hash | VARCHAR | MotherDuck extension build hash |
Example usage
SELECT md_version();
PRAGMA md_version;