Re: Accessing 2 different databases in the same query ? - Mailing list pgsql-general

From Richard Huxton
Subject Re: Accessing 2 different databases in the same query ?
Date
Msg-id 200306020911.36897.dev@archonet.com
Whole thread Raw
In response to Accessing 2 different databases in the same query ?  (Nagib Abi Fadel <nagib_postgres@yahoo.com>)
Responses Re: Accessing 2 different databases in the same query ?  (Nagib Abi Fadel <nagib_postgres@yahoo.com>)
List pgsql-general
On Monday 02 Jun 2003 7:22 am, Nagib Abi Fadel wrote:
> Hi everyone,
>
> Is there a way to access 2 different Tables each one in a different
> database with one sql query ?(or to make references between them)...
>
> Personally i don't believe there's a way because we are talking about two
> different databases, but i'm facing this problem and i would really
> appreciate if anyone could help.

There's a package called "dblink" in the contrib directory of the source
distribution. Might also be available as RPM etc. This sounds like what you
want.

--
  Richard Huxton

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: sql datatypes storage
Next
From: Jean-Michel POURE
Date:
Subject: Re: pgAdmin3 snapshots