PG_AVAILABLE_EXTENSION_VERSIONS
PG_AVAILABLE_EXTENSION_VERSIONS displays extension versions of certain database features. This view is for internal use only. You are advised not to use it.
| Name | Type | Description |
|---|---|---|
| name | name | Extension name |
| version | text | Version name |
| installed | boolean | Specifies whether this extension version is installed. |
| superuser | boolean | Specifies whether only system administrators are allowed to install the extension. |
| relocatable | boolean | Specifies whether the extension can be relocated to another schema. |
| schema | name | Name of the schema that the extension must be installed into (NULL if the extension is partially or fully relocatable) |
| requires | name[] | Names of prerequisite extensions (NULL if none) |
| comment | text | Comment from the extension's control file. |