/ PostgreSQL

PostgreSQL

Drop all tables from a schema

select 'drop table if exists "' || tablename || '" cascade;' 
  from pg_tables
  where schemaname = 'public';