Basic PostgreSQL Question

Started by P. Broennimannabout 14 years ago1 messagesgeneral
Jump to latest
#1P. Broennimann
peter.broennimann@gmail.com

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.