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

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

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

gp_transaction_log

pg_available_extensions