Domain

Types, Constraints & Database Objects

Making meaning and integrity explicit with data types, constraints, views, generated values, and database-side behavior.

  1. Numeric Types And Precision
  2. Text Types Collations And Encoding
  3. Dates Times And Time Zones
  4. Boolean Enum Domain And UUID Types
  5. JSON Arrays And Composite Data
  6. Primary Unique And Check Constraints
  7. Foreign Keys And Referential Actions
  8. Views And Materialized Views
  9. Sequences Generated Columns Triggers And Routines