PG.CENTER connects PostgreSQL documentation, reference, and ecosystem knowledge. Maintained by Pigsty.
Temporal constraints are constraints over ranges. These are available for both PRIMARY KEY and UNIQUE constraints using the WITHOUT OVERLAPS clause, and FOREIGN KEY constraints using the PERIOD clause.
PRIMARY KEY
UNIQUE
WITHOUT OVERLAPS
FOREIGN KEY
PERIOD