phase1_v2.1
Database
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
refreshallmaterializedviews
Parameters
Name
Type
Mode
schema_arg
text
IN
Definition
DECLARE r RECORD; BEGIN RAISE NOTICE 'Refreshing materialized view in schema %', schema_arg; FOR r IN SELECT matviewname FROM pg_matviews WHERE schemaname = schema_arg LOOP RAISE NOTICE 'Refreshing %.%', schema_arg, r.matviewname; EXECUTE 'REFRESH MATERIALIZED VIEW ' || schema_arg || '.' || r.matviewname; END LOOP; RETURN 1; END