33.8. check_constraint_routine_usage

Note: The following description applies both to Postgres-XC and PostgreSQL if not described explicitly. You can read PostgreSQL as Postgres-XC except for version number, which is specific to each product.

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 33-6. check_constraint_routine_usage Columns

NameData TypeDescription
constraint_catalogsql_identifierName of the database containing the constraint (always the current database)
constraint_schemasql_identifierName of the schema containing the constraint
constraint_namesql_identifierName of the constraint
specific_catalogsql_identifierName of the database containing the function (always the current database)
specific_schemasql_identifierName of the schema containing the function
specific_namesql_identifier The "specific name" of the function. See Section 33.40 for more information.