PostgreSQL

36.51. `table_constraints`
Prev	Up	Chapter 36. The Information Schema	Home	Next

36.51. `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 36.49. table_constraints Columns

Name Data Type Description

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`	`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
36.50. `sql_sizing_profiles`	Home	36.52. `table_privileges`

36.50. sql_sizing_profiles

Home

36.52. 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

36.51. table_constraints

Submit correction

36.51. `table_constraints`