I am trying to start a scheduled automation to run a refresh script daily, but it is just not working in FME.
Trying to run:
REFRESH MATERIALIZED VIEW CONCURRENTLY gis.map_filters_mvw WITH DATA;
Thank you,
Kevin
Page 1 / 1
Can you provide a little more info. Are you using desktop workbench or fme server. Please add some screen shots?
Ah good point, I'm using desktop currently but would eventually like to automate on the server. The materialized view is on postgres database. I've just been trying input, sql tranformers with the code above and outputs but it just won't work.