PostgreSQL

PostgreSQL Elephant Logo

36.8. check_constraint_routine_usage

The view check_constraint_routine_usage identifies routines (functions and procedures) that are used by a check constraint. Only those routines are shown that are owned by a currently enabled role.

Table 36.6. check_constraint_routine_usage Columns

Name Data Type Description

constraint_catalog

sql_identifier

Name of the database containing the constraint (always the current database)

constraint_schema

sql_identifier

Name of the schema containing the constraint

constraint_name

sql_identifier

Name of the constraint

specific_catalog

sql_identifier

Name of the database containing the function (always the current database)

specific_schema

sql_identifier

Name of the schema containing the function

specific_name

sql_identifier

The “[.quote]#specific name”# of the function. See Section 36.41 for more information.

+

Prev Up Next

36.7. character_sets

Home

36.9. check_constraints

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.

Copyright © 1996-2023 The PostgreSQL Global Development Group