Postgres Table-Column-ForeignKeys

postgres-table-column-fks.sql

select 
  a.table_name, 
  b.column_name,
  c.constraint_name

from information_schema.tables a
inner join information_schema.columns b
        on a.table_name = b.table_name
inner join information_schema.key_column_usage c
        on b.column_name = c.column_name and a.table_name = c.table_name
inner join information_schema.table_constraints d
        on c.constraint_name = d.constraint_name
        
where a.table_schema = 'public'
  and a.table_type = 'BASE TABLE'
  and d.constraint_type = 'FOREIGN KEY'

order by a.table_name, b.column_name;