pg_available_extension_versions
The pg_available_extension_versions
view lists the specific extension versions that are available for installation. The pg_extension system catalog table shows the extensions currently installed.
The view is read only.
column | type | description |
---|---|---|
name | name | Extension name. |
version | text | Version name. |
installed | boolean | True if this version of this extension is currently installed, False otherwise. |
superuser | boolean | True if only superusers are allowed to install the extension, False otherwise. |
relocatable | boolean | True if extension can be relocated to another schema, False otherwise. |
schema | name | Name of the schema that the extension must be installed into, or NULL if partially or fully relocatable. |
requires | name[] | Names of prerequisite extensions, or NULL if none |
comment | text | Comment string from the extension control file. |
Parent topic: System Catalogs Definitions