resulting from the <replaceable>query</replaceable> and the loop body is

executed for each row. Here is an example:

<programlisting>

CREATE FUNCTIONcs_refresh_mviews() RETURNS integer AS $$

CREATE FUNCTIONrefresh_mviews() RETURNS integer AS $$

DECLARE

mviews RECORD;

BEGIN

RAISE NOTICE 'Refreshing materialized views...';

FOR mviews IN SELECT * FROM cs_materialized_views ORDER BY sort_key LOOP

RAISE NOTICE 'Refreshing all materialized views...';

FOR mviews IN

SELECT n.nspname AS mv_schema,

c.relname AS mv_name,

pg_catalog.pg_get_userbyid(c.relowner) AS owner

FROM pg_catalog.pg_class c

LEFT JOIN pg_catalog.pg_namespace n ON (n.oid = c.relnamespace)

WHERE c.relkind = 'm'

ORDER BY 1

LOOP

-- Now "mviews" has one recordfrom cs_materialized_views

-- Now "mviews" has one recordwith information about the materialized view

RAISE NOTICE 'Refreshing materialized view %s ...', quote_ident(mviews.mv_name);

EXECUTE format('TRUNCATE TABLE %I', mviews.mv_name);

EXECUTE format('INSERT INTO %I %s', mviews.mv_name, mviews.mv_query);

RAISE NOTICE 'Refreshing materialized view %.% (owner: %)...',

quote_ident(mviews.mv_schema),

quote_ident(mviews.mv_name),

quote_ident(mviews.owner);

EXECUTE format('REFRESH MATERIALIZED VIEW %I.%I', mviews.mv_schema, mviews.mv_name);

END LOOP;

RAISE NOTICE 'Done refreshing materialized views.';