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

PG_EXTENSION

PG_EXTENSION records information about the installed extensions. By default, GaussDB provides 18 extensions: PLPGSQL, DIST_FDW, FILE_FDW, LOG_FDW, GC_FDW, DBLINK_FDW, ROACH_API, STREAMING, TSDB, DIMSEARCH, GSREDISTRIBUTE, SECURITY_PLUGIN, GSSTAT_PLUGIN, PKG_DBE_RAW, PKG_DBE_OUTPUT, PKG_DBE_UTILITY, and PKG_DBE_XML. This is a lab feature. Contact Huawei technical support before using it. This system catalog is for internal use only. You are advised not to use it.

DIMSEARCH is no longer supported in the current version due to specification changes. Do not 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. true: yes; false: no.

extversion

text

Version number of the extension

extconfig

oid[]

Configuration information about the extension

extcondition

text[]

Filter conditions for the extension's configuration information