This article is half-done without your Comment! *** Please share your thoughts via Comment ***
In this post, I am sharing a script to find all list of Foreign Keys with source and destination in PostgreSQL.
Using below script, you can easily find all foreign keys of a Postgres Database, and it is also handy for Database Architect to find the different references of a database server.
1 2 3 4 5 6 7 8 9 10 11 12 |
SELECT tc.constraint_name AS ForeignKeyConstraintName ,tc.table_name AS TableName ,kcu.column_name AS ColumnName ,ccu.table_name AS ForeignKeyTableName ,ccu.column_name AS ForeignKeyColumn FROM information_schema.table_constraints AS tc JOIN information_schema.key_column_usage AS kcu ON tc.constraint_name = kcu.constraint_name JOIN information_schema.constraint_column_usage AS ccu ON ccu.constraint_name = tc.constraint_name WHERE tc.constraint_type = 'FOREIGN KEY'; |