postgreSQL - to get list of parent and child relationship tables list

ParentChildList.sql

 SELECT
     n.nspname AS table_schema,
     c.relname AS table_name,
     COALESCE(parents.parent_tables, ARRAY[]::text[]) AS parent_tables,
     COALESCE(children.child_tables, ARRAY[]::text[]) AS child_tables
 FROM
     pg_class c
     JOIN pg_namespace n ON n.oid = c.relnamespace
     LEFT JOIN (
         SELECT
             conrelid,
             ARRAY_AGG(DISTINCT confrelid::regclass::text) AS parent_tables
         FROM pg_constraint
         WHERE contype = 'f'
         GROUP BY conrelid
     ) parents ON parents.conrelid = c.oid
     LEFT JOIN (
         SELECT
             confrelid,
             ARRAY_AGG(DISTINCT conrelid::regclass::text) AS child_tables
         FROM pg_constraint
         WHERE contype = 'f'
         GROUP BY confrelid
     ) children ON children.confrelid = c.oid
 WHERE
     c.relkind = 'r' and n.nspname='mydb'
     AND n.nspname NOT IN ('pg_catalog', 'information_schema')
 ORDER BY
     n.nspname, c.relname;