github.com/supabase/cli@v1.168.1/internal/db/reset/templates/list.sql (about)

     1  -- List user defined schemas, excluding
     2  --  Extension created schemas
     3  --  Supabase managed schemas
     4  select pn.nspname
     5  from pg_namespace pn
     6  left join pg_depend pd
     7    on pd.objid = pn.oid
     8  join pg_roles r 
     9    on pn.nspowner = r.oid
    10  where pd.deptype is null
    11    and not pn.nspname like any($1)
    12    and r.rolname != 'supabase_admin'
    13  order by pn.nspname