Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
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.
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.
Required, but never shown