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

+

Prev Up Next

36.7. character_sets

Home

36.9. check_constraints

Copyright © 1996-2023 The PostgreSQL Global Development Group