select
 tc.table_catalog, tc.table_schema, tc.table_name
from
 information_schema.referential_constraints as rc
 join information_schema.table_constraints as tc
  on (rc.unique_constraint_catalog, rc.unique_constraint_schema, rc.unique_constraint_name)
  = (tc.constraint_catalog, tc.constraint_schema, tc.constraint_name)