WITH RECURSIVE tree AS (
WITH tables_in_inheritance_hierarchy AS (SELECT pn.nspname AS parent_schema, p.oid AS parent_oid, p.relname AS parent_table, pc.nspname AS child_schema, c.oid AS child_oid, c.relname AS child_table
FROM pg_inherits pi INNER JOIN pg_class p ON pi.inhparent=p.oid
INNER JOIN pg_namespace pn ON p.relnamespace=pn.oid
INNER JOIN pg_authid AS ap ON pn.nspowner=ap.oid
INNER JOIN pg_class c ON pi.inhrelid=c.oid
INNER JOIN pg_namespace pc ON c.relnamespace=pc.oid
INNER JOIN pg_authid AS ac ON pc.nspowner=ac.oid
WHERE (pn.nspname='public' OR ap.rolname<>'postgres') 
AND (pc.nspname='public' OR ac.rolname<>'postgres'))
SELECT DISTINCT parent_oid, parent_schema || '.'|| parent_table AS table_in_inhertitance_hierarchy, ''::name AS path,  1 AS depth
FROM tables_in_inheritance_hierarchy AS tih
WHERE NOT EXISTS (SELECT 1
FROM tables_in_inheritance_hierarchy AS tih_check 
WHERE tih.parent_oid=tih_check.child_oid)
UNION ALL SELECT child_oid, child_schema || '.' || child_table AS table_in_inhertitance_hierarchy, tree.path || '/' || tih.parent_schema || '.' || tih.parent_table, tree.depth + 1
FROM tables_in_inheritance_hierarchy AS tih INNER JOIN tree ON tih.parent_oid=tree.parent_oid)
SELECT table_in_inhertitance_hierarchy, tree.path || '/' || tree.table_in_inhertitance_hierarchy AS path, depth-1 AS depth
FROM tree
WHERE depth>1
ORDER BY path;