Re: Joining Between Databases

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: mwilliams <mwilliams(at)cardcommerce(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Joining Between Databases
Date: 2001-10-12 18:11:33
Message-ID: 200110121811.f9CIBXN12818@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> Myself along with a couple of co-workers have been searching for a way to
> join tables from two postgres database. So far there are no indication that
> this is possible, can someone shed some light on this subject.
>
> (P.S We are attemping to do this in the same database instance)

The current snapshot code has /contrib/dblink utility that may help.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2001-10-12 18:12:16 Re: "Relation x does not exist" error when x does exist
Previous Message Stephan Szabo 2001-10-12 18:05:21 Re: COMMIT after an ERROR?