45.52. pg_available_extension_versions

The pg_available_extension_versions view lists the specific extension versions that are available for installation. See also the pg_extension catalog, which shows the extensions currently installed.

Table 45-53. pg_available_extension_versions Columns

NameTypeDescription
namenameExtension name
versiontextVersion name
installedboolTrue if this version of this extension is currently installed
superuserboolTrue if only superusers are allowed to install this extension
relocatableboolTrue if extension can be relocated to another schema
schemanameName of the schema that the extension must be installed into, or NULL if partially or fully relocatable
requiresname[]Names of prerequisite extensions, or NULL if none
commenttextComment string from the extension's control file

The pg_available_extension_versions view is read only.