Historical version. PostgreSQL 12 has reached end of support. 2024-11-21. See the current manual.
51.22. pg_extension
The catalog pg_extension stores information
about the installed extensions. See Section 37.17
for details about extensions.
Table 51.22. pg_extension Columns
| Name | Type | References | Description |
|---|---|---|---|
oid | oid | Row identifier | |
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 of regclass OIDs for the extension's configuration
table(s), or NULL if none |
extcondition | text[] | Array of WHERE-clause filter conditions for the
extension's configuration table(s), or NULL 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. If extrelocatable is true, then
this schema must in fact contain all schema-qualifiable objects
belonging to the extension.
Report a documentation issue
Read the upstream documentation. For corrections, first check the current manual.