3 ms·
An obvious answer would be PL/Python, though is not available on most managed services because they prefer to prevent file system access. An exception is https:
by mslot 3y ago
An obvious answer would be PL/Python, though is not available on most managed services because they prefer to prevent file system access. An exception is https://docs.crunchybridge.com/extensions-and-languages/python https://docs.crunchybridge.com/extensions-and-languages/pyth...
On the other hand, it's quite useful to have a pure SQL cron that cannot do everything, but can run safely in managed services or under a restricted database user. That's probably one of the reasons why practically every managed PostgreSQL service offers pg_cron. Doing more things, like running shell scripts, might limit its usefulness.