Updated on 2024-05-07 GMT+08:00

PG_EXTENSION

PG_EXTENSION records information about the installed extensions. The default GaussDB extensions are PL/pgSQL, DIST_FDW, FILE_FDW, LOG_FDW, DBLINK_FDW, PACKAGES, SECURITY_PLUGIN, GSSTAT_PLUGIN, PKG_DBE_RAW, PKG_DBE_OUTPUT, PKG_DBE_UTILITY, and PKG_DBE_XML. This system catalog is for internal use only. You are advised not to use it.

Table 1 PG_EXTENSION

Name

Type

Description

oid

oid

Row identifier (hidden attribute, which must be specified).

extname

name

Extension name.

extowner

oid

Owner of the extension.

extnamespace

oid

Namespace containing the extension's exported objects.

extrelocatable

Boolean

Whether the extension can be relocated to another namespace. Value true indicates that relocation is allowed.

extversion

text

Version number of the extension.

extconfig

oid[]

Configuration information about the extension.

extcondition

text[]

Filter conditions for the extension's configuration information.