Postgres Pro
Downloads
Home   >   mailing lists

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

From Richard Huxton
Subject Re: select result / functions from another database in
Date
Msg-id 454EF2B8.1070807@archonet.com
Whole thread Raw
In response to select result / functions from another database in plpgsql  (Matthew Peter <survivedsushi@yahoo.com>)
Responses Re: select result / functions from another database in plpgsql
Re: select result / functions from another database
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Matthew Peter
Date:
Subject: select result / functions from another database in plpgsql
Next
From: Richard Huxton
Date:
Subject: Re: No subject