SELECT DISTINCT rc.constraint_schema AS table_schema, fk_table.table_name, rc.constraint_name 
FROM INFORMATION_SCHEMA.referential_constraints AS rc INNER JOIN INFORMATION_SCHEMA.key_column_usage AS fk_table USING (constraint_schema, constraint_name)
INNER JOIN INFORMATION_SCHEMA.constraint_table_usage AS pk_table ON (rc.unique_constraint_schema=pk_table.constraint_schema AND rc.unique_constraint_name=pk_table.constraint_name)
WHERE fk_table.table_schema=pk_table.table_schema 
AND fk_table.table_name=pk_table.table_name 
AND rc.constraint_schema NOT IN (SELECT schema_name
FROM INFORMATION_SCHEMA.schemata
WHERE schema_name<>'public' AND
schema_owner='postgres' AND schema_name IS NOT NULL)
ORDER BY rc.constraint_schema, fk_table.table_name;