Bulk change ownership of foreign tables in a schema

bulk_change.sql

do

$$

DECLARE
	bret record;
	fret text;
	idx text;

BEGIN
	fret := 'CREATE MATERIALIZED VIEW arcfm_test_.%I as select * from arcfm_test_.%I;';
	idx := 'CREATE INDEX ON arcfm_test_.%I USING gist (geom);';

	FOR bret IN
		select * from pg_catalog.pg_class 
		join pg_catalog.pg_foreign_table on oid = ftrelid
		where ftserver = 376514 order by 1 
							LOOP

	IF split_part(bret.relname,'.',2) ~* '[0-9]{2,3}$' THEN
		RAISE NOTICE 'Skipped Delta table: %', bret.relname;
		CONTINUE;
	END IF;

	RAISE NOTICE '%', bret.relname;
	EXECUTE format(fret,bret.relname ||'_mv',bret.relname);
	EXECUTE format(idx,bret.relname ||'_mv');

	END LOOP;

END;
$$ 
language plpgsql