PostgreSQL

53.22. `pg_extension`
Prev	Up	Chapter 53. System Catalogs	Home	Next

53.22. `pg_extension` #

The catalog pg_extension stores information about the installed extensions. See Section 38.17 for details about extensions.

Table 53.22. pg_extension Columns

Column Type Description

Column Type Description
`oid` `oid` Row identifier
`extname` `name` Name of the extension
`extowner` `oid` (references `pg_authid`.`oid`) Owner of the extension
`extnamespace` `oid` (references `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[]` (references `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 oid

Row identifier

extname name

Name of the extension

extowner oid (references pg_authid.oid)

Owner of the extension

extnamespace oid (references 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[] (references 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
53.21. `pg_event_trigger`	Home	53.23. `pg_foreign_data_wrapper`

53.21. pg_event_trigger

Home

53.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

53.22. pg_extension #

Submit correction

53.22. `pg_extension` #