Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Script to find Source and Destination of All Foreign Key Constraint

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.
 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'; 


Popular posts from this blog

How to find the server is whether standby (slave) or primary(master) in Postgresql replication ?

How to Get Table Size, Database Size, Indexes Size, schema Size, Tablespace Size, column Size in PostgreSQL Database

7 Steps to configure BDR replication in postgresql

Postgres Streaming Replication Configuration

vacuumlo - removing large objects orphans from a database PostgreSQL