Postgres Pro
Downloads
Home   >   mailing lists

Basic PostgreSQL Question - Mailing list pgsql-general

From P. Broennimann
Subject Basic PostgreSQL Question
Date
Msg-id CACm4aU__PymAB8uhk15KbZYs5UFrWZg2HQhkCg=hOhUXGC=UfQ@mail.gmail.com
Whole thread Raw
List pgsql-general
Tree view
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.

pgsql-general by date:

Previous
From: "Tefft, Michael J"
Date:
Subject: RE: [GENERAL] PostgreSQL counterpart to DBMS_METADATA?‏
Next
From: Raymond O'Donnell
Date:
Subject: Re: [GENERAL] RE: [GENERAL] PostgreSQL counterpart to DBMS_METADATA?‏