Recursively lists table inheritance in Postgres

show_inheritance.sql

SELECT parentns.nspname as "parent schema", parent.relname as "parent table", childns.nspname "child schema", child.relname as "child table"
FROM pg_catalog.pg_inherits inh 
        INNER JOIN pg_catalog.pg_class as parent ON (inh.inhparent = parent.oid) 
    INNER JOIN pg_catalog.pg_namespace as parentns ON (parent.relnamespace = parentns.oid)
	INNER JOIN pg_catalog.pg_class as child ON (inh.inhrelid = child.oid) 
    INNER JOIN pg_catalog.pg_namespace as childns ON (child.relnamespace = childns.oid)
ORDER BY parent.relname, child.relname;