PostgreSQL - Drop all tables in current DB

DO $$
DECLARE
 tbl pg_tables%ROWTYPE;
BEGIN
 FOR tbl IN SELECT * FROM pg_tables
 WHERE schemaname = 'public'
 LOOP
 EXECUTE 'DROP TABLE ' || tbl.tablename || ' CASCADE;';
 END LOOP;
END$$

Related protips

Have a fresh tip? Share with Coderwall community!