Name: | check_constraint_routine_usage |
Owner: | postgres |
Has rules: | |
Has Triggers: | |
Comment: |
Name | Type | Length | |
|
constraint_catalog | sql_identifier | -1 |
|
constraint_schema | sql_identifier | -1 |
|
constraint_name | sql_identifier | -1 |
|
specific_catalog | sql_identifier | -1 |
|
specific_schema | sql_identifier | -1 |
|
specific_name | sql_identifier | -1 |
CREATE VIEW check_constraint_routine_usage AS
SELECT (current_database())::sql_identifier AS constraint_catalog, (nc.nspname)::sql_identifier AS constraint_schema, (c.conname)::sql_identifier AS constraint_name, (current_database())::sql_identifier AS specific_catalog, (np.nspname)::sql_identifier AS specific_schema, ((((p.proname)::text || '_'::text) || (p.oid)::text))::sql_identifier AS specific_name FROM pg_namespace nc, pg_constraint c, pg_depend d, pg_proc p, pg_namespace np WHERE ((((((((nc.oid = c.connamespace) AND (c.contype = 'c'::"char")) AND (c.oid = d.objid)) AND (d.classid = ('pg_constraint'::regclass)::oid)) AND (d.refobjid = p.oid)) AND (d.refclassid = ('pg_proc'::regclass)::oid)) AND (p.pronamespace = np.oid)) AND pg_has_role(p.proowner, 'USAGE'::text));
ALTER TABLE information_schema.check_constraint_routine_usage OWNER TO postgres;
See Also
List of views