Postgres Pro
Downloads
Home   >   mailing lists

Re: Querying From two databases - Mailing list pgsql-sql

From Bruce Momjian
Subject Re: Querying From two databases
Date
Msg-id 200404191830.i3JIUpV10701@candle.pha.pa.us
Whole thread Raw
In response to Querying From two databases  (Pallav Kalva <pkalva@deg.cc>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: cmpofu@iupui.edu (Charity M)
Date:
Subject: Re: Database triggers
Next
From: "scott.marlowe"
Date:
Subject: Re: SQL script