Enumerated types v15
Name | Native | Alias | Description |
---|---|---|---|
ENUM | ✅ | Static, ordered set of values, 4 bytes storage. Max length is limited by NAMEDATALEN setting in PostgreSQL. |
Example
This example shows how to create ENUM
types and use them:
ENUM
types are case sensitive, and whitespace in ENUM
types is significant.
The ENUM
types and its labels are stored in the pg_enum
system catalog.
For more information on enumerated data types, see the PostgreSQL documentation.
- On this page
- Example