Hi there I have installed pgAgent (scheduling) in the default "postres" database on my server. I read somewhere that this is where the linux pgAgent expects to find its tables.
My own application database is called "xyz" on the same server. Now I need to create pgAgent "jobs" from my "xyz" stored functions. How can I access the "postgres" database from my stored functions to execute INSERT statements... Thanks & cheers, P.