PostgreSQL

51.22. `pg_extension`
Prev	Up	Chapter 51. System Catalogs	Home	Next

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

Name	Type	References	Description
`oid`	`oid`		Row identifier
`extname`	`name`		Name of the extension
`extowner`	`oid`	`pg_authid.oid`	Owner of the extension
`extnamespace`	`oid`	`pg_namespace.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[]`	`pg_class.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

oid

Row identifier

extname

name

Name of the extension

extowner

oid

pg_authid.oid

Owner of the extension

extnamespace

oid

pg_namespace.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[]

pg_class.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 “[.quote]#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.

Prev	Up	Next
51.21. `pg_event_trigger`	Home	51.23. `pg_foreign_data_wrapper`

51.21. pg_event_trigger

Home

51.23. pg_foreign_data_wrapper

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.

PostgreSQL

51.22. pg_extension

Submit correction

51.22. `pg_extension`