Refresh all materialized views in a schema (Postgres)

matviews_refresh.sql

CREATE OR REPLACE FUNCTION remote.refresh()
 RETURNS bool
 LANGUAGE plpgsql
AS $$
	DECLARE
		r record;
	BEGIN
		for r in SELECT matviewname FROM pg_catalog.pg_matviews where schemaname = 'remote'
		loop 
			raise notice 'Refreshing %...', r.matviewname;
			execute 'REFRESH MATERIALIZED VIEW CONCURRENTLY remote.' || quote_ident(r.matviewname) || ';';
		end loop;
		return true;
	END;
$$
;