September 26, 2024: PostgreSQL 17 Released!
Supported Versions: Current (17) / 16 / 15 / 14 / 13 / 12
Development Versions: devel
Unsupported versions: 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1

54.2. 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.

Table 54.2. pg_available_extensions Columns

Column Type

Description

name name

Extension name

default_version text

Name of default version, or NULL if none is specified

installed_version text

Currently installed version of the extension, or NULL if not installed

comment text

Comment string from the extension's control file


The pg_available_extensions view is read-only.

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.