Kamnev Ilya kamnev8823
velosipedist
/ postgresql-list-foreign-keys.sql
Created
October 31, 2013 13:52
List all foreign keys in PostgreSQL database, analog of MySQL SHOW CREATE TABLE mytable;
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| --- Source: http://solaimurugan.blogspot.ru/2010/10/list-out-all-forien-key-constraints.html | |
| 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, |