PostgreSQL

37.52. `table_constraints`
Prev	Up	Chapter 37. The Information Schema	Home	Next

37.52. `table_constraints`

The view table_constraints contains all constraints belonging to tables that the current user owns or has some privilege other than SELECT on.

Table 37.50. table_constraints Columns

Column Type Description

Column 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` `yes_or_no` `YES` if the constraint is deferrable, `NO` if not
`initially_deferred` `yes_or_no` `YES` if the constraint is deferrable and initially deferred, `NO` if not
`enforced` `yes_or_no` Applies to a feature not available in PostgreSQL (currently always `YES`)

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 yes_or_no

YES if the constraint is deferrable, NO if not

initially_deferred yes_or_no

YES if the constraint is deferrable and initially deferred, NO if not

enforced yes_or_no

Applies to a feature not available in PostgreSQL (currently always YES)

Prev	Up	Next
37.51. `sql_sizing`	Home	37.53. `table_privileges`

37.51. sql_sizing

Home

37.53. table_privileges

Submit correction

If you see anything in the documentation that is not correct, does not match your experience with the particular feature or requires further clarification, please use this form to report a documentation issue.

PostgreSQL

37.52. table_constraints

Submit correction

37.52. `table_constraints`