Tag Info

New answers tagged

0

here's a quick and ugly query that make the job : with nsp_oid as ( select oid from pg_namespace where nspname='mySchema' ), dep_oid as ( select p.objid as oid from pg_depend p join nsp_oid n on refobjid = n.oid ), rew_oid as( select p.objid as oid from pg_depend p join dep_oid d on p.refobjid = d.oid where ...


0

You can use pg_depend table to resolve that :  select objid::regclass from pg_depend where refobjid = (select oid from pg_namespace where nspname='mySchema');



Top 50 recent answers are included