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.