PG_AVAILABLE_EXTENSION_VERSIONS¶
PG_AVAILABLE_EXTENSION_VERSIONS displays the extension versions of certain database features.
Name | Type | Description |
---|---|---|
name | name | Extension name |
version | text | Version name |
installed | boolean | The value is true if the version of this extension is currently installed. |
superuser | boolean | The value is true if only system administrators are allowed to install this extension. |
relocatable | boolean | The value is true if an extension can be relocated to another schema. |
schema | name | Name of the schema that the extension must be installed into. The value is null if the extension is partially or fully relocatable. |
requires | name[] | Names of prerequisite extensions. The value is null if there are no prerequisite extensions. |
comment | text | Comment string from the extension's control file |