Re: select result / functions from another database in plpgsql - Mailing list pgsql-general

From Matthew Peter
Subject Re: select result / functions from another database in plpgsql
Date
Msg-id 20061106201653.99644.qmail@web35203.mail.mud.yahoo.com
Whole thread Raw
In response to Re: select result / functions from another database in  (Richard Huxton <dev@archonet.com>)
List pgsql-general
--- Richard Huxton <dev@archonet.com> 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 the db_link or dbi_link packages. These are exactly what you
> are after.
>
> --
>    Richard Huxton
>    Archonet Ltd
>


Perfect. Leave it to me not to check the contrib package first :) Thanks again




____________________________________________________________________________________
Cheap talk?
Check out Yahoo! Messenger's low PC-to-Phone call rates.
http://voice.yahoo.com

pgsql-general by date:

Previous
From: Marc Munro
Date:
Subject: Re: [pgsql-general] Daily digest v1.6578 (20 messages)
Next
From: AgentM
Date:
Subject: Re: PostgreSQL in an embedded platform