DO $$
DECLARE
    table_name text;
BEGIN
    FOR table_name IN 
        SELECT tablename 
        FROM pg_tables 
        WHERE schemaname = 'public' 
        AND tablename LIKE 'your_pattern%'  -- 替换为你的表名前缀/模式
    LOOP
        EXECUTE 'DROP TABLE IF EXISTS ' || quote_ident(table_name) || ' CASCADE';
        RAISE NOTICE 'Dropped table: %', table_name;
    END LOOP;
END $$;

CREATE OR REPLACE FUNCTION drop_tables_like(pattern text) RETURNS void AS $$
DECLARE
    table_record record;
BEGIN
    FOR table_record IN 
        SELECT tablename 
        FROM pg_tables 
        WHERE schemaname = 'public' 
        AND tablename LIKE pattern
    LOOP
        EXECUTE 'DROP TABLE IF EXISTS ' || quote_ident(table_record.tablename) || ' CASCADE';
        RAISE NOTICE 'Dropped table: %', table_record.tablename;
    END LOOP;
END;
$$ LANGUAGE plpgsql;

-- 使用示例
SELECT drop_tables_like('temp_%');

-- 生成删除语句但不执行
SELECT 'DROP TABLE IF EXISTS ' || quote_ident(tablename) || ' CASCADE;' 
FROM pg_tables 
WHERE schemaname = 'public' 
AND tablename LIKE 'your_pattern%';

-- 如果确认无误，可以复制输出结果并执行