--- Richard Huxton wrote:
> Matthew Peter wrote:
> > I have DB1 and DB2 pg_databases... I then have a function in DB2 that
> > wants some results from DB1, is it possible to query another db? Like
> > how \! lets you hit the command line... but I need it in plpgsql if
> > possible.
>
> Look into
On 11/6/06, Richard Broersma Jr <[EMAIL PROTECTED]> wrote:
> check out dblink contrib module for starters. Maybe take a look at
> pl/sh, which looks pretty neat.
Is there really such a thing as PL/SH? or are you refering to piping sql
queries into psql?
http://plsh.projects.postgresql.org/
> check out dblink contrib module for starters. Maybe take a look at
> pl/sh, which looks pretty neat.
Is there really such a thing as PL/SH? or are you refering to piping sql
queries into psql?
Regards,
Richard Broersma Jr.
---(end of broadcast)--
On 11/6/06, Matthew Peter <[EMAIL PROTECTED]> wrote:
I have DB1 and DB2 pg_databases... I then have a function in DB2 that wants
some results from DB1, is it possible to query another db? Like how \! lets
you hit the command line... but I need it in plpgsql if possible.
Also, I know functions a
I have DB1 and DB2 pg_databases... I then have a function in DB2 that wants some results from DB1, is it possible to query another db? Like how \! lets you hit the command line... but I need it in plpgsql if possible.Also, I know functions are local to db (unless it inserted into template1 prior to
