'Resetting all values in a column to zero at desired time using Postgresql
I’m working on an app that adds an increment of 1 to an int value, entries whenever a user clicks a button. I made use of Postgresql DBMS to store these values. I have done this successfully, however I want all values in the entries column of my database table to get reset to 0 at midnight everyday. How do I go about this?
My OS is Windows 10. I have full access on my pc and on my database. I installed postgres by downloading the setup from the official site.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|