PG_AVAILABLE_EXTENSIONS

PG_AVAILABLE_EXTENSIONS displays the extended information about certain database features.

Table 1 PG_AVAILABLE_EXTENSIONS columns

Name

Type

Description

name

name

Extension name

default_version

text

Name of default version. The value is NULL if none is specified.

installed_version

text

Currently installed version of the extension. The value is NULL if no version is installed.

comment

text

Comment string from the extension's control file