June 27th, 2024: PostgreSQL 17 Beta 2 Released!
Supported Versions: Current (16) / 15 / 14 / 13 / 12
Development Versions: 17 / devel
Unsupported versions: 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1
This documentation is for an unsupported version of PostgreSQL.
You may want to view the same page for the current version, or one of the other supported versions listed above instead.
52.2. pg_available_extensions
Prev  Up Chapter 52. System Views Home  Next

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

Prev  Up  Next
52.1. Overview  Home  52.3. pg_available_extension_versions