Re: Accessing 2 different databases in the same query ?

From: Richard Huxton <dev(at)archonet(dot)com>
To: Nagib Abi Fadel <nagib_postgres(at)yahoo(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Accessing 2 different databases in the same query ?
Date: 2003-06-02 08:11:36
Message-ID: 200306020911.36897.dev@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jean-Michel POURE 2003-06-02 08:31:00 Re: pgAdmin3 snapshots
Previous Message Richard Huxton 2003-06-02 08:09:20 Re: sql datatypes storage