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. Otherwise, the value is false. |
| superuser | Boolean | Specifies whether only system administrators are allowed to install the extension. Otherwise, the value is false. |
| relocatable | Boolean | Specifies whether the extension can be relocated to another schema. Otherwise, the value is false. |
| 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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
