PG_AVAILABLE_EXTENSION_VERSIONS
PG_AVAILABLE_EXTENSION_VERSIONS displays the extension versions of certain database features.
Column | 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 |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.

