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