pg_cron
pg_cron copied to clipboard
[FEATURE REQUEST] Run SQL file using 'cron.schedule'
Hello,
I was wondering whether it'd be feasible to support running SQL files from cron.schedule
. I have multiple chained commands I wanted to execute in one go, and to support arbitrary flexibility, I wanted to package that up in a SQL file. I'm having a difficult time finding a way to run SQL files from within a SQL command, and I thought that presented an opportunity for a third-party function to have that functionality. I would definitely like to use that feature!
Thanks Ying
I'd also be supportive of being able to schedule "multiple" commands using the same name and an order index in case a SQL file isn't possible.