Skip to main content
Question

How to update or refresh a materialized view?

kbraun77
Contributor
Forum|alt.badge.img+9

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

    juanmahere
    1 person upvoted this
    • juanmahere
      juanmahere

    2 replies

    j.botterill
    Influencer
    Forum|alt.badge.img+36
    • j.botterillInfluencer
    • Influencer
    • May 5, 2022

    Can you provide a little more info. Are you using desktop workbench or fme server. Please add some screen shots?

    kbraun77
    Contributor
    Forum|alt.badge.img+9
    • kbraun77Contributor
    • Author
    • Contributor
    • May 5, 2022

    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.

    juanmahere
    1 person upvoted this
    • juanmahere
      juanmahere

    Reply


    Helpful Members This Week

    Community Stats

    31,140
    Posts
    118,062
    Replies
    38,759
    Members

    Latest FME

    Terms & ConditionsCookie settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie settings
    A product of
    Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.