pg_extension — PostgreSQL system catalog

The PostgreSQL pg_extension system catalog: full column reference (names, types, descriptions), catalog relationships and version support.

The Sev-1 Admin
The Sev-1 Admin  ·  1 min read

Summary

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

(Description quoted from the official PostgreSQL documentation.)

Columns

The pg_extension system catalog exposes the following columns (names, types and descriptions are taken verbatim from the PostgreSQL documentation):

  • 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

Related catalogs

This object references the following other system catalogs:

Version applicability

Present in PostgreSQL 17, 18, 19 (verified against each release’s documentation). This is a long-standing system object that also exists in earlier PostgreSQL releases.

Related & references

Reference: PostgreSQL documentation — pg_extension.