From 293913568e6a7a86fd1479e1cff8e2ecb58d6568 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 13 Apr 2024 15:44:03 +0200 Subject: Adding upstream version 16.2. Signed-off-by: Daniel Baumann --- .../sgml/html/infoschema-table-constraints.html | 73 ++++++++++++++++++++++ 1 file changed, 73 insertions(+) create mode 100644 doc/src/sgml/html/infoschema-table-constraints.html (limited to 'doc/src/sgml/html/infoschema-table-constraints.html') diff --git a/doc/src/sgml/html/infoschema-table-constraints.html b/doc/src/sgml/html/infoschema-table-constraints.html new file mode 100644 index 0000000..87dbe90 --- /dev/null +++ b/doc/src/sgml/html/infoschema-table-constraints.html @@ -0,0 +1,73 @@ + +37.52. table_constraints
37.52. table_constraints
Prev UpChapter 37. The Information SchemaHome 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 +

+ 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) +

+ nulls_distinct yes_or_no +

+

+ If the constraint is a unique constraint, then YES + if the constraint treats nulls as distinct or NO if + it treats nulls as not distinct, otherwise null for other types of + constraints. +


Prev Up Next
37.51. sql_sizing Home 37.53. table_privileges
\ No newline at end of file -- cgit v1.2.3