Skip site navigation (1) Skip section navigation (2)

Re: Querying From two databases

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: Pallav Kalva <pkalva(at)deg(dot)cc>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Querying From two databases
Date: 2004-04-19 18:30:51
Message-ID: 200404191830.i3JIUpV10701@candle.pha.pa.us (view raw or flat)
Thread:
Lists: pgsql-sql
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(at)candle(dot)pha(dot)pa(dot)us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

In response to

pgsql-sql by date

Next:From: scott.marloweDate: 2004-04-19 20:17:48
Subject: Re: [SQL] SQL script
Previous:From: Bruno Wolff IIIDate: 2004-04-19 17:45:51
Subject: Re: three-way join

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group