PostgreSQL批量清空数据库

1.模糊查询需要清空的表

SELECT table_name
FROM information_schema.tables
WHERE table_name LIKE 'fxp%';

2.清空表名为xxx的表格

TRUNCATE TABLE xxx;

3.批量清空模糊匹配的表

DO $$
DECLARE
  table_name VARCHAR;
BEGIN
  FOR table_name IN
    SELECT table_name
    FROM information_schema.tables
    WHERE table_name LIKE 's-127%'
  LOOP
    EXECUTE 'TRUNCATE TABLE ' || table_name;
  END LOOP;
END $$;