| PostgreSQL 9.2.4 Documentation | ||||
|---|---|---|---|---|
| Prev | Up | Chapter 45. System Catalogs | Next | |
The catalog pg_extension stores information about the installed extensions. See Section 35.15 for details about extensions.
Table 45-21. pg_extension Columns
| Name | Type | References | Description |
|---|---|---|---|
| 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 "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.
Please use this form to add your own comments regarding your experience with particular features of PostgreSQL, clarifications of the documentation, or hints for other users. Please note, this is not a support forum, and your IP address will be logged. If you have a question or need help, please see the faq, try a mailing list, or join us on IRC. Note that submissions containing URLs or other keywords commonly found in 'spam' comments may be silently discarded. Please contact the webmaster if you think this is happening to you in error.
Proceed to the comment form.