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 PG 18 manual ↗

The pg_available_extensions view lists the extensions that are available for installation.

Kind
System views
Columns in this snapshot
4
Definition source
English manual

Columns 4

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. PG 18 → 19changed
  2. PG 9.0 → 9.1added

Definition snapshot: english-manuals:01a75a0cd1b23bfaac9133e0ed5… · English manual source