pg_available_extensions
The pg_available_extensions view lists the extensions 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
- kind
- view
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- name, default_version, installed_version, comment
- runtime verified
- false
- source
- english-manual
Definition PG 18
The pg_available_extensions view lists the extensions 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 |
| default_version | text | Nullable | Name of default version, or NULL if none is specified |
| installed_version | text | Nullable | Currently installed version of the extension, or NULL if not installed |
| comment | text | Nullable | Comment string from the extension's control file |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:25de0626317b731ca844f2536f89c4def127dff1b4fe81561061a1dc80c90477
Text language: en · catalog-bilingual-repair:25de0626317b731ca844f2536f89c4def127dff1b4fe81561061a1dc80c90477