drop_postgres_objects.sql

DO $$ DECLARE
    r RECORD;
BEGIN
    FOR r IN (
        SELECT tablename as entry
        FROM pg_tables
        WHERE
            schemaname = current_schema())
    LOOP
        EXECUTE 'DROP TABLE ' || quote_ident(r.entry) || ' CASCADE';
    END LOOP;
END $$;

DO $$ DECLARE
    r RECORD;
BEGIN
    FOR r IN (
        SELECT sequencename as entry
        FROM pg_sequences
        WHERE
            schemaname = current_schema())
    LOOP
        EXECUTE 'DROP SEQUENCE ' || quote_ident(r.entry) || '';
    END LOOP;
END $$;

DO $$ DECLARE
    r RECORD;
BEGIN
    FOR r IN (
        SELECT viewname as entry
        FROM pg_views
        WHERE
            schemaname = current_schema())
    LOOP
        EXECUTE 'DROP VIEW ' || quote_ident(r.entry) || '';
    END LOOP;
END $$;