49.22. pg_extension
The catalogpg_extension stores information about the installed extensions. SeeSection 35.15 for details about extensions.
Table 49.22. pg_extension Columns
| Name | Type | References | Description |
|---|---|---|---|
oid | oid | Row identifier (hidden attribute; must be explicitly selected) | |
extname | name | Name of the extension | |
extowner | oid | | Owner of the extension |
extnamespace | oid | | Schema containing the extension's exported objects |
extrelocatable | bool | True if extension can be relocated to another schema | |
extversion | text | Version name for the extension | |
extconfig | oid[] | | Array ofregclass OIDs for the extension's configuration table(s), orNULL if none |
extcondition | text[] | Array ofWHERE-clause filter conditions for the extension's configuration table(s), orNULL if none |
Note that unlike most catalogs with a“namespace” column,extnamespace is not meant to imply that the extension belongs to that schema. Extension names are never schema-qualified. Rather,extnamespace indicates the schema that contains most or all of the extension's objects. Ifextrelocatable is true, then this schema must in fact contain all schema-qualifiable objects belonging to the extension.