Help Center/ GaussDB(DWS)/ Developer Guide/ Standard data warehouse (8.3.0.x)/ GaussDB(DWS) System Catalogs and Views/ System Catalogs/ PG_EXTENSION
Updated on 2024-11-05 GMT+08:00
View PDF
Share

PG_EXTENSION

PG_EXTENSION records information about the installed extensions. By default, GaussDB(DWS) has 15 extensions, namely, PLPGSQL, DIST_FDW, FILE_FDW, ROACH_API, HDFS_FDW, BTREE_GIN, GC_FDW, LOG_FDW, HSTORE, PACKAGES, PLDBGAPI, TSDB, DIMSEARCH, UUID-OSSP, and PGCRYPTO.

Table 1 PG_EXTENSION

Name

Type

Description

extname

name

Extension name

extowner

oid

Owner of the extension

extnamespace

oid

Namespace containing the extension's exported objects

extrelocatable

boolean

Its value is true if the extension can be relocated to another schema.

extversion

text

Version number of the extension

extconfig

oid[]

Configuration information about the extension

extcondition

text[]

Filter conditions for the extension's configuration information
Parent topic: System Catalogs