show all foreign key in a database

gistfile1.md

Idea from: http://stackoverflow.com/questions/1152260/postgres-sql-to-list-table-foreign-keys

SELECT r.conname, ct.table_name, pg_catalog.pg_get_constraintdef(r.oid, true) as condef FROM pg_catalog.pg_constraint r, information_schema.constraint_table_usage ct WHERE r.contype = 'f' and r.conname = ct.constraint_name ORDER BY 1;