Help Center> Data Warehouse Service> Developer Guide> System Catalogs and System Views> System Catalogs> PG_EXTENSION
PG_EXTENSION
PG_EXTENSION records information about the installed extensions. By default, GaussDB(DWS) has 12 extensions, that is, PLPGSQL, DIST_FDW, FILE_FDW, HDFS_FDW, HSTORE, PLDBGAPI, DIMSEARCH, PACKAGES, GC_FDW, UUID-OSSP, LOG_FDW, and ROACH_API.
| 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
Last Article: PG_ENUM
Next Article: PG_EXTENSION_DATA_SOURCE
Did this article solve your problem?
Thank you for your score！Your feedback would help us improve the website.