PostgreSQL: Generate script to drop all tables in public schema

select 'drop table if exists "' || tablename || '" cascade;' 
  from pg_tables
 where schemaname = 'public'; -- or any other schema