Delete/Drop multiple tables based on multiple prefixes - PostgreSQL

drop_multiple_tables.sql

-- Inspect the generated statements before you actually execute: comment RAISE and uncomment the EXECUTE
DO
$do$
    DECLARE
        _tbl text;
    BEGIN
        FOR _tbl IN
            SELECT c.oid::regclass::text                                            -- escape identifier and schema-qualify!
            FROM pg_catalog.pg_class c
                     JOIN pg_catalog.pg_namespace n ON n.oid = c.relnamespace
            WHERE n.nspname NOT LIKE 'pg_%'                                         -- exclude system schemas
              AND c.relname SIMILAR TO '%(GENERAL|indicators|ZONING)%' || '%'       -- your tables names prefixes
              AND c.relkind = 'r' -- only tables
            LOOP
                   RAISE NOTICE '%',
--                 EXECUTE
                    'DROP TABLE ' || _tbl;
            END LOOP;
    END
$do$;