Materialised view - refresh

From: Krithika Venkatesh <krithikavenkatesh31(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Materialised view - refresh
Date: 2017-07-11 06:28:55
Message-ID: CAP7eca1EHOq1Mg9cW78dJiyD4YBJsGhXS361HPqHHm7BnOqmqw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

I have a materialised view which needs to refreshed every half an hour.

Is it possible to refresh the view without using triggers.

Do we have something similar to DBMS_SCHEDULER.CREATE_JOB in postgresql to
create a job that can be scheduled to refresh the views periodically.

Thanks in advance..

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2017-07-11 07:28:52 Re: tsquery error
Previous Message Stephen Davies 2017-07-11 06:00:33 tsquery error