https://www.chepkov.com/w/index.php?action=history&feed=atom&title=Postgresql_foreign_keys 2026-04-30T17:28:51Z Revision history for this page on the wiki MediaWiki 1.43.6 https://www.chepkov.com/w/index.php?title=Postgresql_foreign_keys&diff=520&oldid=prev 2012-12-20T23:59:20Z

<p>Created page with &quot;&lt;source lang=&#039;sql&#039;&gt; SELECT tc.constraint_name, tc.constraint_type, tc.table_name, kcu.column_name, tc.is_deferrable, tc.initially_deferred, rc.match_option AS match_type, rc.u...&quot;</p> <p><b>New page</b></p><div>&lt;source lang=&#039;sql&#039;&gt;<br /> SELECT tc.constraint_name,<br /> tc.constraint_type,<br /> tc.table_name,<br /> kcu.column_name,<br /> tc.is_deferrable,<br /> tc.initially_deferred,<br /> rc.match_option AS match_type,<br /> rc.update_rule AS on_update,<br /> rc.delete_rule AS on_delete,<br /> ccu.table_name AS references_table,<br /> ccu.column_name AS references_field<br /> FROM information_schema.table_constraints tc<br /> LEFT JOIN information_schema.key_column_usage kcu<br /> ON tc.constraint_catalog = kcu.constraint_catalog<br /> AND tc.constraint_schema = kcu.constraint_schema<br /> AND tc.constraint_name = kcu.constraint_name<br /> LEFT JOIN information_schema.referential_constraints rc<br /> ON tc.constraint_catalog = rc.constraint_catalog<br /> AND tc.constraint_schema = rc.constraint_schema<br /> AND tc.constraint_name = rc.constraint_name<br /> LEFT JOIN information_schema.constraint_column_usage ccu<br /> ON rc.unique_constraint_catalog = ccu.constraint_catalog<br /> AND rc.unique_constraint_schema = ccu.constraint_schema<br /> AND rc.unique_constraint_name = ccu.constraint_name<br /> WHERE lower(tc.constraint_type) in (&#039;foreign key&#039;) ;<br /> &lt;/source&gt;</div>

Vvc