↑↓ select ↵ open ⌫ change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

Supported versions: Current (18) / 17 / 16 / 15 / 14
Development versions: 19 / devel
Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1
Historical version. PostgreSQL 9.5 reached end of support in February 2021. See the current version for supported releases.
PostgreSQL 9.5.25 Documentation
Prev Up Chapter 49. System Catalogs Next

49.57. 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 49-58. pg_available_extensions Columns

Name 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 Home Next
System Views Up pg_available_extension_versions

Report a documentation issue

Read the upstream documentation. For corrections, first check the current version.