meorajrul · May 15, 2018 04:26
diff --git a/postgres_drop_all_table_and_schema.sql b/postgres_drop_all_table_and_schema.sql
 DO $$ DECLARE
    tabname RECORD;
 BEGIN
    FOR tabname IN (SELECT tablename 
                    FROM pg_tables 
                    WHERE schemaname = current_schema()) 
 LOOP
    EXECUTE 'DROP TABLE IF EXISTS ' || quote_ident(tabname.tablename) || ' CASCADE';
 END LOOP;
 END $$;
	DO $$ DECLARE
	tabname RECORD;
	BEGIN
	FOR tabname IN (SELECT tablename
	FROM pg_tables
	WHERE schemaname = current_schema())
	LOOP
	EXECUTE 'DROP TABLE IF EXISTS ' \|\| quote_ident(tabname.tablename) \|\| ' CASCADE';
	END LOOP;
	END $$;