Postgres: SQL to list table foreign keys?

Question

Is there a way using SQL to list all foreign keys for a given table? I know the table name / schema and I can plug that in.

Answer 1

SELECT a.table_name, a.column_name, a.constraint_name, c.owner,

-- referenced pk

c.r_owner, c_pk.table_name r_table_name, c_pk.constraint_name r_pk

FROM all_cons_columns a

JOIN all_constraints c ON a.owner = c.owner

AND a.constraint_name = c.constraint_name

JOIN all_constraints c_pk ON c.r_owner = c_pk.owner

AND c.r_constraint_name = c_pk.constraint_name

WHERE c.constraint_type = 'R'

AND a.table_name = :TableName