---

select
    n.nspname as table_schema,
    c.relname as table_name,
    con.conname,
    pg_get_constraintdef(con.oid) as constraint_definition
from pg_constraint con
join pg_class c
    on c.oid = con.conrelid
join pg_namespace n
    on n.oid = c.relnamespace
where con.contype = 'f'
  and con.confrelid = 'ourpension.npo_pension_agreement'::regclass
order by n.nspname, c.relname;