PostgreSQL

PostgreSQL Elephant Logo

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

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

+

Prev Up Next

37.7. character_sets

Home

37.9. check_constraints

Copyright © 1996-2023 The PostgreSQL Global Development Group