refresh-materialized-views.sql

CREATE OR REPLACE FUNCTION refresh_materialized_views() RETURNS VOID
AS
$body$
DECLARE
  result integer;
BEGIN
  EXECUTE (SELECT string_agg('REFRESH MATERIALIZED VIEW ' || oid::regclass::text, ';')
             FROM   pg_class
            WHERE  relkind = 'm');
  RETURN;
END;
$body$
LANGUAGE plpgsql;

SELECT refresh_materialized_views();