PG_EXTENSION

PG_EXTENSION records information about the installed extensions. By default, GaussDB provides the following extensions: PL/pgSQL, DIST_FDW, FILE_FDW, LOG_FDW, GC_FDW, DBLINK_FDW, ROACH_API, STREAMING, TSDB, DIMSEARCH, GSREDISTRIBUTE, SECURITY_PLUGIN, GSSTAT_PLUGIN, NUMERIC_ENHANCE, PKG_DBE_RAW, PKG_DBE_OUTPUT, PKG_DBE_UTILITY, PKG_DBE_XML, PKG_ILM, PKG_DBE_XMLGEN, and PKG_DBE_DESCRIBE. 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	Specifies whether the extension can be relocated to another namespace. The value can be true (yes) or 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.