ENUM
Enumerated type with safe value addition via ALTER TYPE and safe value removal via MIGRATE REMOVE.
Types
ENUM, composite, range, domain, virtual, and base type declarations.
| Page | Description |
|---|---|
| ENUM | Enumerated type with safe value addition and removal |
| Composite | Row-shaped composite type |
| Range | Custom range type over a subtype |
| Domain | Constrained alias over a base type |
| Virtual | DPG-only annotation that generates no SQL |
| Base | Shell / base type for C-implemented types |
Composite
Row-shaped composite type declared with TYPE name AS (...).
Range
Custom range type over a subtype using TYPE name AS RANGE (...).
Domain
Constrained alias over a base type with DOMAIN name AS type.
Virtual
VIRTUAL TYPE — typed schema for JSON/JSONB columns, resolved to jsonb in SQL.
Base (Shell) Type
C-implemented base types declared with TYPE name (...).