System Catalogs / System catalogs
pg_extension
Read the PG 18 manualThe catalog pg_extension stores information about the installed extensions.
Reading PG 18current·documented in 17 of 24 versions, 9.1 to 20
- Kind
- System catalogs
- Columns in this snapshot
- 8
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 8
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
oid | oidNOT NULL | Row identifier |
extname | nameNOT NULL | Name of the extension |
extowner | oidNOT NULL | Owner of the extension pg_authid.oid |
extnamespace | oidNOT NULL | Schema containing the extension's exported objects pg_namespace.oid |
extrelocatable | boolNOT NULL | True if extension can be relocated to another schema |
extversion | textNOT NULL | Version name for the extension |
extconfig | oid[] | Array of regclass OIDs for the extension's configuration table(s), or NULL if none pg_class.oid |
extcondition | text[] | Array of WHERE-clause filter conditions for the extension's configuration table(s), or NULL if none |
Column history across versions
Version history 8
Definition snapshot: english-manuals:694e77f2d5ca730e46798aabbf0… · English manual source