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

check-circle-line exclamation-circle-line close-line
Scroll to top icon