PostgreSQLでテーブルを全て削除する方法
truncate
SELECT 'TRUNCATE TABLE ' || ARRAY_TO_STRING(ARRAY_AGG(relname), ',') || ';' AS query FROM pg_stat_user_tables;
schemaを1回消して再作成
drop schema public cascade; create schema public;
SELECT 'TRUNCATE TABLE ' || ARRAY_TO_STRING(ARRAY_AGG(relname), ',') || ';' AS query FROM pg_stat_user_tables;
drop schema public cascade; create schema public;