postgresql - Postgresql:每午夜 12 点执行一次查询
问题描述
我使用的是最新的 postgres 版本,而且我是新手。我只是想知道我怎样才能有一个在每个午夜触发或使用 now()::time = '23:59:59' 的插入查询语句?可能吗?提前致谢
解决方案
Postgres 没有任何开箱即用的功能来满足您的需求。您需要类似的东西pg_cron
来安排查询:
https://github.com/citusdata/pg_cron
或psql
通过系统的cron
调度程序安排查询。
推荐阅读
- javascript - click event is triggered by scrolling
- javascript - 有没有办法在 HTML 元素中获取 javascript 变量的值?
- php - DOMPDF takes time when it generates a PDF with Images
- c# - Getting error while decrypting data through AES/ECB/PKCS7 algorithm - "Specified key is not a valid size for this algorithm"
- flutter - Another exception was thrown: Error: Could not find the correct Provider
above this History Widget flutter - kotlin - 为什么我在 Kotlin 中出现块体错误的函数中需要“返回”表达式?
- react-native - How to send bearer token as parameter and retrieve it in another screen in React Native
- docker - Docker: Error response from daemon - why is it not showing in docker container ls?
- sql - How to import a JSON file into postgresql databse?
- javascript - JQuery Input Field clickable again after using the blur() method