–创建全量刷新物化视图函数
create or replace function tri_tableName_mview_func() returns trigger as $$
declare
begin
refresh materialized view t_view1 with data;
refresh materialized view t_view2 with data;
return null;
end;
$$ language plpgsql;
–创建触发函数执行的触发器
create trigger tri_tableName_idu
after insert or update or delete on t_m
for each statement
execute procedure tri_tableName_mview_func();