script to truncate all tables from postgres database

truncate_tables.sql

DO $$ DECLARE
  r RECORD;
BEGIN
  FOR r IN (SELECT tablename FROM pg_tables 
            WHERE schemaname = current_schema()
            AND current_database() = 'make sure you have the right database') LOOP
    EXECUTE 'TRUNCATE ' || quote_ident(r.tablename) || ' CASCADE';
  END LOOP;
END $$;