原创 PostgreSQL 作者：陈洪光 时间：2019-12-18 15:00:22 757 0
1
2
3
4
5
6
7
8
9
10
11
create or replace function tri_tableName_mview_func() returns trigger as $$
declare
begin
refresh materialized view concurrently tableName_mview with data;
return null;
end;
$$ language plpgsql;
create trigger tri_tableName_idu
after insert or update or delete on tableName
for each statement
execute procedure tri_tableName_mview_func();
