PostgreSQL 19 ← 18
← Catalog atlas / pg_available_extension_versions
SYSTEM VIEW · System view
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.
Checked column by column against a PostgreSQL 18.6 instance · Raw measurement record ↗
Columns PostgreSQL 18
pg_available_extension_versionsPostgreSQL 19 beta 3 is a preview snapshot; the structure can still change before release.
| COLUMN | TYPE | DESCRIPTION |
|---|---|---|
name |
name |
Extension name |
version |
text |
Version name |
installed |
booleanDocumented as:bool |
True if this version of this extension is currently installed |
superuser |
booleanDocumented as:bool |
True if only superusers are allowed to install this extension (but see trusted) |
trusted |
booleanDocumented as:bool |
True if the extension can be installed by non-superusers with appropriate privileges |
relocatable |
booleanDocumented as: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 |
Columns marked "implicit" are not included in SELECT *; some early statistics views are completed from same-version source, and the extra provenance is shown in the column description.
Common system columns 0
System attributes PostgreSQL provides, normally not expanded by SELECT *. Kept separately so they are not mixed in with ordinary columns.
| Columns | Type | attnum |
|---|
Column evolution matrix
Hover a cell for the column typePresentAdded / type or attribute changeRemoved
9.0 is the coverage baseline; a column already present in the baseline is not marked as added. The matrix aligns columns by name, so a rename appears as the old column removed and a new column added.
Evolution timeline
Changes between adjacent majorsPostgreSQL 13 ← 12
PostgreSQL 9.1 ← 9.0Catalog added
Compare any two versions
Pick two versions to see added, removed, and retyped columns. The interactive comparison needs JavaScript; the evolution timeline reads fine without it.