Programming query execution Postgres

Question

I need to execute update querys routinely over a Postgres table. Is it possible to program an automatic execution of the query, let's say, every day at 15:00 hs? The Postgres version is 9.5, I'm working on Windows 7.

Answer 1

There is no task scheduling functionality built into PostgreSQL.

You can use an extension like pg_cron, but I don't know how easy it is to build that on Windows.

The simplest way would probably to use the Windows task scheduler to start your job regularly.