PostgreSQL Script to Refresh All Materialized Views in your database dynamically

refresh_materialized_views.sql

CREATE OR REPLACE FUNCTION refresh_all_materialized_views()
RETURNS VOID AS $$
DECLARE
   matview RECORD;
   total_views INTEGER;
   views_processed INTEGER := 0;
BEGIN
   SELECT COUNT(*) INTO total_views FROM pg_matviews;
   FOR matview IN (SELECT schemaname, matviewname FROM pg_matviews)
   LOOP
      EXECUTE 'REFRESH MATERIALIZED VIEW ' || matview.schemaname || '.' || matview.matviewname;
      views_processed := views_processed + 1;
      RAISE NOTICE 'Refreshing materialized view: % ( % of % )', matview.matviewname, views_processed, total_views;
   END LOOP;
END;
$$ LANGUAGE plpgsql;

run this code in psql