51.65. pg_available_extensions

51.65. `pg_available_extensions`
Prev	Up	Chapter 51. System Catalogs	Home	Next

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

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
51.64. System Views	Home	51.66. `pg_available_extension_versions`