PostgreSQL: Drop all schemas

postgresql-drop-all-schemas.sql

DO $$ DECLARE 
    namespace RECORD; 
BEGIN 
    FOR namespace IN (SELECT s.nspname as schema from pg_catalog.pg_namespace s where nspname not in ('information_schema', 'pg_catalog', 'public', 'everest') and nspname not like 'pg_%') 
LOOP 
    EXECUTE 'DROP SCHEMA IF EXISTS ' || quote_ident(namespace.schema) || ' CASCADE'; 
END LOOP; 
END $$;