PG_EXTENSION

PG_EXTENSION records information about the installed extensions. By default, GaussDB provides 14 extensions: PLPGSQL, DIST_FDW, FILE_FDW, LOG_FDW, GC_FDW, PACKAGES, ROACH_API, STREAMING, TSDB, HSTORE, DIMSEARCH, GSREDISTRIBUTE, and SECURITY_PLUGIN.

DIMSEARCH is no longer supported in the current version due to specification changes. Do not use it.

**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	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