↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

System Catalogs / System views

pg_available_extensions

Read the PG 18 manual

The pg_available_extensions view lists the extensions 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
4
Definition source
English manual
Metadata snapshot
18.6

Columns 4

As listed in the PostgreSQL 18 manual.

ColumnTypeDescription / reference
namenameExtension name
default_versiontextName of default version, or NULL if none is specified
installed_versiontextCurrently installed version of the extension, or NULL if not installed
commenttextComment string from the extension's control file
Column history across versions
Version history 2
  1. 18 → 19 changed
  2. 9.0 → 9.1 added

Definition snapshot: english-manuals:cff06718cbba3e1c602627824f4… · English manual source