PostgreSQL provides several ways to constrain values inserted and updated within tables.
One of these is the availability of table and column
constraints
.
PostgreSQL also supports an advanced object-relational table concept called
inheritance
.
Inheritance allows separate tables to have an explicit parent-child relationship and, through this relationship, share
columns in a hierarchical fashion.
The following sections document both types of SQL constraints, as well as the creation and application of inherited
tables.