↑↓ 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
Pre-release documentation. PostgreSQL 19 Beta 3 is a testing release. The final release may differ.
53.3. pg_available_extensions
Prev  Up Chapter 53. System Views Home  Next

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

location text

The location where the extension is installed. If it is in the standard system location, then the value will be $system, while if it is found in the path specified by the extension_control_path GUC then the full path will be shown. Only superusers can see this information.

comment text

Comment string from the extension's control file

The pg_available_extensions view is read-only.

Prev  Up  Next
53.2. pg_aios  Home  53.4. pg_available_extension_versions

Report a documentation issue

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