たまーによく使うのでメモ。
select 'DROP TABLE ' || tablename || ';' from pg_tables where schemaname not like 'pg_%' and schemaname != 'information_schema';
たまーによく使うのでメモ。
select 'DROP TABLE ' || tablename || ';' from pg_tables where schemaname not like 'pg_%' and schemaname != 'information_schema';