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.