Help to drop all triggers, types and tables in PostgreSQL

drop-database.sql

-- Drop all triggers
DO $$ 
DECLARE 
    r RECORD; 
BEGIN 
    -- Loop through all tables in the 'public' schema
    FOR r IN (SELECT tablename FROM pg_tables WHERE schemaname = 'public') 
    LOOP 
        -- Drop all triggers associated with each table
        EXECUTE 'DO $$ BEGIN EXECUTE ''DROP TRIGGER IF EXISTS ALL ON ' || quote_ident(r.tablename) || '''; EXCEPTION WHEN others THEN NULL; END $$;';
    END LOOP; 
END $$;

-- Drop all custom types
DO $$ 
DECLARE 
    r RECORD; 
BEGIN 
    -- Loop through all custom types in the 'public' schema
    FOR r IN (SELECT typname FROM pg_type WHERE typnamespace = 'public'::regnamespace AND typtype = 'c') 
    LOOP 
        -- Drop each custom type
        EXECUTE 'DROP TYPE IF EXISTS ' || quote_ident(r.typname) || ' CASCADE'; 
    END LOOP; 
END $$;

-- Drop Views
DO $$ 
DECLARE 
    r RECORD; 
BEGIN 
    -- Loop through all views in the 'public' schema
    FOR r IN (SELECT table_name FROM information_schema.views WHERE table_schema = 'public') 
    LOOP 
        -- Drop each view
        EXECUTE 'DROP VIEW IF EXISTS ' || quote_ident(r.table_name) || ' CASCADE'; 
    END LOOP; 
END $$;

-- Drop tables
DROP SCHEMA public CASCADE;
CREATE SCHEMA public;

-- Verify drops
SELECT * FROM pg_trigger WHERE tgname != 'RI_ConstraintTrigger';
SELECT * FROM pg_type WHERE typnamespace = 'public'::regnamespace AND typtype = 'c';
SELECT table_name FROM information_schema.views WHERE table_schema = 'public';