pg_cron icon indicating copy to clipboard operation
pg_cron copied to clipboard

[FEATURE REQUEST] Run SQL file using 'cron.schedule'

Open yingw787 opened this issue 4 years ago • 1 comments

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

yingw787 avatar Jun 03 '20 23:06 yingw787

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.

joeyparis avatar Jul 15 '20 17:07 joeyparis