System Catalogs / System views
pg_available_extension_versions
Read the PG 18 manualThe pg_available_extension_versions view lists the specific extension versions that are available for installation.
Reading PG 18current·documented in 17 of 24 versions, 9.1 to 20
- Kind
- System views
- Columns in this snapshot
- 9
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 9
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
name | name | Extension name |
version | text | Version name |
installed | bool | True if this version of this extension is currently installed |
superuser | bool | True if only superusers are allowed to install this extension (but see trusted) |
trusted | bool | True if the extension can be installed by non-superusers with appropriate privileges |
relocatable | bool | True if extension can be relocated to another schema |
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's control file |
Column history across versions
Definition snapshot: english-manuals:f8ae5d7543e0cbd68570ba6c193… · English manual source