select open change scope Open full search

PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.

SYSTEM CATALOGS / SYSTEM CATALOGS

The pg_enum catalog contains entries showing the values and labels for each enum type.

Kind
System catalogs
Columns in this snapshot
4
Definition source
English manual

Columns 4

ColumnTypeDescription / reference
oidoidRow identifier
enumtypidoidThe OID of the pg_type entry owning this enum value
pg_type.oid
enumsortorderfloat4The sort position of this enum value within its enum type
enumlabelnameThe textual label for this enum value
Column history across versions
Version history 3
  1. PG 11 → 12changed
  2. PG 9.2 → 9.3changed
  3. PG 9.0 → 9.1changed

Definition snapshot: english-manuals:175aeef3d36ff48f2b3b28631ab… · English manual source