On 5/4/2017 2:50 PM, John R Pierce wrote:
But there's an extension - pg_cron:
https://www.citusdata.com/blog/2016/09/09/pgcron-run-periodic-jobs-in-postgres/
there's also pg_agent which is a cron-like extension, usually bundled
with pg_admin but also available standalone
https://www.pgadmin.org/docs4/dev/pgagent.html
oh, it should be made clear... both of these extensions require an OS
level cron/scheduler job to be run every minute or whatever, this job
invokes some SQL stuff which checks the pg_cron or pg_agent tables and
runs whatever sql tasks are due.
--
john r pierce, recycling bits in santa cruz
