Re: accessing two databases at the same time - Mailing list pgsql-general

From Darko Prenosil
Subject Re: accessing two databases at the same time
Date
Msg-id 200303052158.05213.darko.prenosil@finteh.hr
Whole thread Raw
In response to accessing two databases at the same time  (Peter Choe <choepete@mindspring.com>)
List pgsql-general
On Wednesday 05 March 2003 20:17, Peter Choe wrote:
> if i have database 'A' with a table called 'a' and another database 'B'
> with a table called 'b', is there a way to do a select using both databases
> and their tables?
>
> select * from A.a, B.b;
>

See the dblink in contrib directory or
if You are familyar with postgres libpq client interface, look at
ftp://gborg.postgresql.org/pub/plpq/devel/plpq_src.tar.gz

> Peter Choe
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faqs/FAQ.html



pgsql-general by date:

Previous
From: Peter Choe
Date:
Subject: accessing two databases at the same time
Next
From: Ian Barwick
Date:
Subject: Re: accessing two databases at the same time