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.