ar45 · September 14, 2016 21:19
diff --git a/postgres_drop_tables.sql b/postgres_drop_tables.sql
 DO $$ 
 	DECLARE 
 		stmt TEXT;
 BEGIN
 	FOR stmt IN SELECT 'DROP TABLE IF EXISTS "' || tablename || '" CASCADE;' 
 	  from pg_tables
 	WHERE schemaname = 'public'
 	LOOP
 		EXECUTE stmt;
 	END LOOP;
 END;
 $$
 ;
	DO $$
	DECLARE
	stmt TEXT;
	BEGIN
	FOR stmt IN SELECT 'DROP TABLE IF EXISTS "' \|\| tablename \|\| '" CASCADE;'
	from pg_tables
	WHERE schemaname = 'public'
	LOOP
	EXECUTE stmt;
	END LOOP;
	END;
	$$
	;