SELECT c.relname AS child, p.relname AS parent, n.table_schema as scheme
FROM
pg_inherits JOIN pg_class AS c ON (inhrelid=c.oid)
JOIN pg_class as p ON (inhparent=p.oid)
JOIN information_schema.tables as n ON (n.table_name = c.relname)