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.