PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

SYSTEM CATALOGS / SYSTEM CATALOGS

pg_extension

Read PG 18 manual ↗

The catalog pg_extension stores information about the installed extensions.

Kind: System catalogs
Columns in this snapshot: 8
Definition source: English manual

Columns 8

Column	Type	Description / reference
`oid`	`oid`	Row identifier
`extname`	`name`	Name of the extension
`extowner`	`oid`	Owner of the extension pg_authid.oid
`extnamespace`	`oid`	Schema containing the extension's exported objects pg_namespace.oid
`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 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

Column	9.0	9.1	9.2	9.3	9.4	9.5	9.6	10	11	12	13	14	15	16	17	18	19	20
`oid`	·	·	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`extname`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`extowner`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`extnamespace`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`extrelocatable`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`extversion`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`extconfig`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●
`extcondition`	·	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●	●

Version history 8

Definition snapshot: english-manuals:405cc4adc30c4c53a79a9e25e4d… · English manual source