pg_enum
The pg_enum catalog contains entries showing the values and labels for each enum type. The internal representation of a given enum value is actually the OID of its associated row in pg_enum.
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, enumtypid, enumsortorder, enumlabel
- runtime verified
- false
- source
- english-manual
Definition PG 18
The pg_enum catalog contains entries showing the values and labels for each enum type. The internal representation of a given enum value is actually the OID of its associated row in pg_enum.
Catalog columns
| Column | Type | Nullability | Description |
|---|---|---|---|
| oid | oid | Not null | Row identifier |
| enumtypid | oid | Not null | The OID of the pg_type entry owning this enum value |
| enumsortorder | float4 | Not null | The sort position of this enum value within its enum type |
| enumlabel | name | Not null | The textual label for this enum value |
Compare versions
Source references
Full definition and evidence JSON
Definition sources
center · PostgreSQL 18 · catalog-bilingual-repair:781aef725a25b1a351b4721a02a0919c2bdfd9c0d0c2028c185acf02d1f625e9
Text language: en · catalog-bilingual-repair:781aef725a25b1a351b4721a02a0919c2bdfd9c0d0c2028c185acf02d1f625e9