b4tman · January 31, 2020 12:30
diff --git a/pg_remove_tab-oids.sql b/pg_remove_tab-oids.sql

 CREATE LANGUAGE plpgsql;
 create function m1_exec(text) returns void as $BODY$BEGIN execute $1; END;$BODY$ language plpgsql;
 select m1_exec('ALTER TABLE ' || table_name || ' SET WITHOUT OIDS;') from information_schema.tables where table_schema = 'public';
 drop function m1_exec

	CREATE LANGUAGE plpgsql;
	create function m1_exec(text) returns void as $BODY$BEGIN execute $1; END;$BODY$ language plpgsql;
	select m1_exec('ALTER TABLE ' \|\| table_name \|\| ' SET WITHOUT OIDS;') from information_schema.tables where table_schema = 'public';
	drop function m1_exec