PostgreSQLでテーブルやビューの依存関係を調べるSQL

--tableの作成
create table table01 (testid int);
create table table02 (testid int);

--viewの作成
create view view01 as select * from table01;
create view view02 as select * from view01;
create view view03 as select * from view01;
create view view04 as select * from view02 union all select * from view03;
create view view05 as select * from table01 union all select * from table02;

select distinct
       d.refobjid as id1
      ,c1.relname as name1
      ,c1.relkind as kind1
      ,case c1.relkind when 'r' then 'table' when 'v' then 'view' else '' end as kindname1
      ,d.objid as id2
      ,c2.relname as name2
      ,c2.relkind as kind2
      ,case c2.relkind when 'r' then 'table' when 'v' then 'view' else '' end as kindname2
  from pg_depend d
 inner join pg_class c1
    on d.refobjid = c1.oid
   and c1.relkind in ('r','v') --r=table, v=view
   and c1.relnamespace = (select oid from pg_namespace where nspname = 'public')
   and d.refobjsubid != 0
 inner join pg_rewrite r
    on d.objid = r.oid
 inner join pg_class c2
    on r.ev_class = c2.oid
   and c2.relkind in ('r','v') --r=table, v=view
 order by d.refobjid
      ,d.objid