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.

English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.

Reading PG 18·Select a recorded version

9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

kind: view
lang: en
measured attributes: true
metadata release: 18.6
runtime columns: name, version, installed, superuser, trusted, relocatable, schema, requires, comment
runtime verified: false
source: english-manual

Definition PG 18

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.

Catalog columns

Column	Type	Nullability	Description
name	name	Nullable	Extension name
version	text	Nullable	Version name
installed	bool	Nullable	True if this version of this extension is currently installed
superuser	bool	Nullable	True if only superusers are allowed to install this extension (but see trusted)
trusted	bool	Nullable	True if the extension can be installed by non-superusers with appropriate privileges
relocatable	bool	Nullable	True if extension can be relocated to another schema
schema	name	Nullable	Name of the schema that the extension must be installed into, or NULL if partially or fully relocatable
requires	name[]	Nullable	Names of prerequisite extensions, or NULL if none
comment	text	Nullable	Comment string from the extension's control file

Compare versions

Source references

Original manual reference

Full definition and evidence JSON

Definition sources

center · PostgreSQL 18 · catalog-bilingual-repair:ba2fc6c61fab38ea6359adcb9bed9db0521f58e1dfbf9a208f50ffa58a38b984

Text language: en · catalog-bilingual-repair:ba2fc6c61fab38ea6359adcb9bed9db0521f58e1dfbf9a208f50ffa58a38b984