PostgreSQL 7.4beta4 Documentation
Prev | Fast Backward | Chapter 32. The Information Schema | Fast Forward | Next

# 32.34. table_constraints

The view table_constraints contains all constraints belonging to tables owned by the current user.

Table 32-32. table_constraints Columns

Name | Data Type | Description
--- | --- | ---
constraint_catalog | `sql_identifier` | Name of the database that contains the constraint (always the current database)
constraint_schema | `sql_identifier` | Name of the schema that contains the constraint
constraint_name | `sql_identifier` | Name of the constraint
table_catalog | `sql_identifier` | Name of the database that contains the table (always the current database)
table_schema | `sql_identifier` | Name of the schema that contains the table
table_name | `sql_identifier` | Name of the table
constraint_type | `character_data` | Type of the constraint: CHECK, FOREIGN KEY, PRIMARY KEY, or UNIQUE
is_deferrable | `character_data` | YES if the constraint is deferrable, NO if not
initially_deferred | `character_data` | YES if the constraint is deferrable and initially deferred, NO if not

Prev | Home | Next
sql_sizing_profiles | Up | table_privileges