Postgres Pro
Downloads
Home   >   mailing lists

[GENERAL] Materialised view - refresh - Mailing list pgsql-general

From Krithika Venkatesh
Subject [GENERAL] Materialised view - refresh
Date
Msg-id CAP7eca1EHOq1Mg9cW78dJiyD4YBJsGhXS361HPqHHm7BnOqmqw@mail.gmail.com
Whole thread Raw
Responses Re: [GENERAL] Materialised view - refresh  (Adam Brusselback <adambrusselback@gmail.com>)
List pgsql-general
Tree view
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..

pgsql-general by date:

Previous
From: Stephen Davies
Date:
Subject: [GENERAL] tsquery error
Next
From: Albe Laurenz
Date:
Subject: Re: [GENERAL] tsquery error