Updated on 2024-06-03 GMT+08:00

PG_AVAILABLE_EXTENSIONS

PG_AVAILABLE_EXTENSIONS displays the extension information about certain database features. This view is for internal use only. You are advised not to use it. For details about the columns, see Table 1.

Table 1 PG_AVAILABLE_EXTENSIONS columns

Name

Type

Description

name

name

Extension name

default_version

text

Name of the default version (NULL if none is specified)

installed_version

text

Currently installed version of the extension (NULL if no version is installed)

comment

text

Comment from the extension's control file.