Re: select result / functions from another database in

From: Richard Huxton <dev(at)archonet(dot)com>
To: Matthew Peter <survivedsushi(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: select result / functions from another database in
Date: 2006-11-06 08:30:48
Message-ID: 454EF2B8.1070807@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Richard Huxton 2006-11-06 08:36:04 Re: No subject
Previous Message Matthew Peter 2006-11-06 08:25:49 select result / functions from another database in plpgsql