Name: | constraint_table_usage |
Owner: | postgres |
Has rules: | |
Has Triggers: | |
Comment: |
Name | Type | Length | |
|
table_catalog | sql_identifier | -1 |
|
table_schema | sql_identifier | -1 |
|
table_name | sql_identifier | -1 |
|
constraint_catalog | sql_identifier | -1 |
|
constraint_schema | sql_identifier | -1 |
|
constraint_name | sql_identifier | -1 |
CREATE VIEW constraint_table_usage AS
SELECT (current_database())::sql_identifier AS table_catalog, (nr.nspname)::sql_identifier AS table_schema, (r.relname)::sql_identifier AS table_name, (current_database())::sql_identifier AS constraint_catalog, (nc.nspname)::sql_identifier AS constraint_schema, (c.conname)::sql_identifier AS constraint_name FROM pg_constraint c, pg_namespace nc, pg_class r, pg_namespace nr WHERE (((((c.connamespace = nc.oid) AND (r.relnamespace = nr.oid)) AND (((c.contype = 'f'::"char") AND (c.confrelid = r.oid)) OR ((c.contype = ANY (ARRAY['p'::"char", 'u'::"char"])) AND (c.conrelid = r.oid)))) AND (r.relkind = 'r'::"char")) AND pg_has_role(r.relowner, 'USAGE'::text));
ALTER TABLE information_schema.constraint_table_usage OWNER TO postgres;
See Also
List of views