PostgreSQL

54.2. `pg_available_extensions`
Prev	Up	Chapter 54. System Views	Home	Next

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

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

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
54.1. Overview	Home	54.3. `pg_available_extension_versions`

54.1. Overview

Home

54.3. pg_available_extension_versions

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.

PostgreSQL

54.2. pg_available_extensions #

Submit correction

54.2. `pg_available_extensions` #