Can someone give me a simple example of the way in which I might be able to call a stored procedure or query using pgagent? I have never scripted a postgres .sql etc to run via cron or pgagent and an example of the syntax would be helpful. In pgagent terms, the Step is set up as SQL, and it's the definition that I would like an example of. I am guessing that one would save the routine off to a .sql file, then call via \i? The pgagent docs are sparse, no examples given, and there are not many posts on this subject that I can find. -- View this message in context: http://www.nabble.com/Running-a-stored-procedure-via-pgagent%2C-need-an-example-tf4262256.html#a12129548 Sent from the PostgreSQL - general mailing list archive at Nabble.com. ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
