Table Constraint

Description

Table constraints, are constraints definition that are not tied to a particular column, and it can encompass more than one column.

Click here to navigate to the PostgreSQL documentation page for this syntax.

Grammar Syntax

[ CONSTRAINT constraint_name ]
{ CHECK ( expression ) [ NO INHERIT ] |
  UNIQUE [ NULLS [ NOT ] DISTINCT ] ( column_name [, ... ] ) index_parameters |
  PRIMARY KEY ( column_name [, ... ] ) index_parameters |
  EXCLUDE [ USING index_method ] ( exclude_element WITH operator [, ... ] ) index_parameters [ WHERE ( predicate ) ] |
  FOREIGN KEY ( column_name [, ... ] ) REFERENCES reftable [ ( refcolumn [, ... ] ) ]
    [ MATCH FULL | MATCH PARTIAL | MATCH SIMPLE ] [ ON DELETE referential_action ] [ ON UPDATE referential_action ] }
[ DEFERRABLE | NOT DEFERRABLE ] [ INITIALLY DEFERRED | INITIALLY IMMEDIATE ]

Navigate to the following pages to get more details about the translation spec for the subsections of the content-source section.

1. Check Constraint

2. Unique Constraint

3. Primary Key Constraint

4. Exclude Constraint

5. Foreign Key Constraint