pg_extension
The catalog pg_extension stores information about the installed extensions. See Section 36.17 for details about extensions.
English manual coverage begins with PostgreSQL 7.4. Source history and runtime observations have their own recorded version boundaries.
Reading PG 18·Select a recorded version
- kind
- catalog
- lang
- en
- measured attributes
- true
- metadata release
- 18.6
- runtime columns
- oid, extname, extowner, extnamespace, extrelocatable, extversion, extconfig, extcondition
- runtime verified
- false
- source
- english-manual
Definition PG 18
The catalog pg_extension stores information about the installed extensions. See Section 36.17 for details about extensions.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| oid | oid | Not null | Row identifier |
| extname | name | Not null | Name of the extension |
| extowner | oid | Not null | Owner of the extension |
| extnamespace | oid | Not null | Schema containing the extension's exported objects |
| extrelocatable | bool | Not null | True if extension can be relocated to another schema |
| extversion | text | Not null | Version name for the extension |
| extconfig | oid[] | Nullable | Array of regclass OIDs for the extension's configuration table(s), or NULL if none |
| extcondition | text[] | Nullable | Array of WHERE-clause filter conditions for the extension's configuration table(s), or NULL if none |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:dd39a0ed387f3d012d117b6d5cc7cf23f20d66b8f899ea324eebcc5bdc04de02
Text language: en · catalog-bilingual-repair:dd39a0ed387f3d012d117b6d5cc7cf23f20d66b8f899ea324eebcc5bdc04de02