The pg_extension catalog provides information about the installed extensions.
| Column name | Data type | Description |
|---|---|---|
oid |
oid |
A row identifier. |
extname |
name |
An extension name. |
extowner |
oid (references pg_authid.oid) |
The OID of the role that owns the extension. |
extnamespace |
oid (references pg_namespace.oid) |
The OID of the schema that contains the extension’s exported objects. |
extrelocatable |
bool |
Specifies whether the extension can be relocated to another schema (TRUE) or not (FALSE). |
extversion |
text |
The version name of the extension. |
extconfig |
oid[] (references pg_class.oid) |
An array of regclass OIDs representing the extension’s configuration table(s).NULL – No configuration tables. |
extcondition |
text[] |
An array of WHERE-clause filter conditions for the extension’s configuration table(s).NULL – No filter conditions. |