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