I created a materialized view named
view_table_A on a foreign data wrapper table
table_A. What I want is for the view to be automatically updated after every new insert in
table_A. I tried to do this with triggers but it didn't work.
Is it possible to refresh a materialized view automatically without using triggers?