PostgreSQL

37.8. `check_constraint_routine_usage`
Prev	Up	Chapter 37. The Information Schema	Home	Next

37.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 37.6. check_constraint_routine_usage Columns

Column Type Description

Column 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 37.45 for more information.

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 37.45 for more information.

Prev	Up	Next
37.7. `character_sets`	Home	37.9. `check_constraints`

37.7. character_sets

Home

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

PostgreSQL

37.8. check_constraint_routine_usage

Submit correction

37.8. `check_constraint_routine_usage`