↑↓ select↵ open⌫ change scopeOpen full search

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

Supported versions: Current (18) / 17 / 16 / 15 / 14
Development versions: 19 / 20devel
Unsupported versions: 13 / 12 / 11 / 10 / 9.6 / 9.5 / 9.4 / 9.3 / 9.2 / 9.1 / 9.0 / 8.4 / 8.3
Historical version. PostgreSQL 9.0 has reached end of support. 2015-10-08. See the current manual.

45.19. pg_enum

The pg_enum catalog contains entries matching enum types to their associated values and labels. The internal representation of a given enum value is actually the OID of its associated row in pg_enum. The OIDs for a particular enum type are guaranteed to be ordered in the way the type should sort, but there is no guarantee about the ordering of OIDs of unrelated enum types.

Table 45-19. pg_enum Columns

NameTypeReferencesDescription
enumtypidoidpg_type.oidThe OID of the pg_type entry owning this enum value
enumlabelname The textual label for this enum value

Report a documentation issue

Read the upstream documentation. For corrections, first check the current manual.