Name: | referential_constraints |
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 |
|
unique_constraint_catalog | sql_identifier | -1 |
|
unique_constraint_schema | sql_identifier | -1 |
|
unique_constraint_name | sql_identifier | -1 |
|
match_option | character_data | -1 |
|
update_rule | character_data | -1 |
|
delete_rule | character_data | -1 |
CREATE VIEW referential_constraints AS
SELECT (current_database())::sql_identifier AS constraint_catalog, (ncon.nspname)::sql_identifier AS constraint_schema, (con.conname)::sql_identifier AS constraint_name, (CASE WHEN (npkc.nspname IS NULL) THEN NULL::name ELSE current_database() END)::sql_identifier AS unique_constraint_catalog, (npkc.nspname)::sql_identifier AS unique_constraint_schema, (pkc.conname)::sql_identifier AS unique_constraint_name, (CASE con.confmatchtype WHEN 'f'::"char" THEN 'FULL'::text WHEN 'p'::"char" THEN 'PARTIAL'::text WHEN 'u'::"char" THEN 'NONE'::text ELSE NULL::text END)::character_data AS match_option, (CASE con.confupdtype WHEN 'c'::"char" THEN 'CASCADE'::text WHEN 'n'::"char" THEN 'SET NULL'::text WHEN 'd'::"char" THEN 'SET DEFAULT'::text WHEN 'r'::"char" THEN 'RESTRICT'::text WHEN 'a'::"char" THEN 'NO ACTION'::text ELSE NULL::text END)::character_data AS update_rule, (CASE con.confdeltype WHEN 'c'::"char" THEN 'CASCADE'::text WHEN 'n'::"char" THEN 'SET NULL'::text WHEN 'd'::"char" THEN 'SET DEFAULT'::text WHEN 'r'::"char" THEN 'RESTRICT'::text WHEN 'a'::"char" THEN 'NO ACTION'::text ELSE NULL::text END)::character_data AS delete_rule FROM (((pg_namespace ncon JOIN pg_constraint con ON ((ncon.oid = con.connamespace))) JOIN pg_class c ON ((con.conrelid = c.oid))) LEFT JOIN (pg_constraint pkc JOIN pg_namespace npkc ON ((pkc.connamespace = npkc.oid))) ON (((con.confrelid = pkc.conrelid) AND _pg_keysequal(con.confkey, pkc.conkey)))) WHERE ((((c.relkind = 'r'::"char") AND (con.contype = 'f'::"char")) AND ((pkc.contype = ANY (ARRAY['p'::"char", 'u'::"char"])) OR (pkc.contype IS NULL))) AND pg_has_role(c.relowner, 'USAGE'::text));
ALTER TABLE information_schema.referential_constraints OWNER TO postgres;
See Also
List of views