Version:

`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: 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.