System Catalogs / System catalogs
pg_enum
Read the PG 18 manualThe pg_enum catalog contains entries showing the values and labels for each enum type.
Reading PG 18current·documented in 20 of 24 versions, 8.3 to 20
- Kind
- System catalogs
- Columns in this snapshot
- 4
- Definition source
- English manual
- Metadata snapshot
- 18.6
Columns 4
As listed in the PostgreSQL 18 manual.
| Column | Type | Description / reference |
|---|---|---|
oid | oidNOT NULL | Row identifier |
enumtypid | oidNOT NULL | The OID of the pg_type entry owning this enum value pg_type.oid |
enumsortorder | float4NOT NULL | The sort position of this enum value within its enum type |
enumlabel | nameNOT NULL | The textual label for this enum value |
Column history across versions
Definition snapshot: english-manuals:83e256ab52f7f2fac6e38561f05… · English manual source