Thread: Querying From two databases

Hi,
   I am new to postgres and I need to do a query which joins two tables 
from different databases. Can you please advice me on how to achieve 
this in postgres.

Thanks!
Pallav

Pallav Kalva wrote:
> Hi,
> 
>     I am new to postgres and I need to do a query which joins two tables 
> from different databases. Can you please advice me on how to achieve 
> this in postgres.

Sure, see /contrib/dblink in the source distribution.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073