Re: querying two connections in one query - Mailing list pgsql-general

From Sven Willenberger
Subject Re: querying two connections in one query
Date
Msg-id 1106580982.19213.20.camel@lanshark.dmv.com
Whole thread Raw
In response to querying two connections in one query  (Abdul-Wahid Paterson <abdulwahid@gmail.com>)
List pgsql-general
On Mon, 2005-01-24 at 14:48 +0000, Abdul-Wahid Paterson wrote:
> Hi,
>
> Is it possible, perhaps through some extension, to query two database
> through one SQL select statement where the two databases have
> different connections? Something similar to how you can link databases
> in Oracle.
>

I believe contrib/dblink may be what you are seeking ...

Sven


pgsql-general by date:

Previous
From: "Rick Schumeyer"
Date:
Subject: Postgres 8.0 on RHEL
Next
From: Michael Fuhr
Date:
Subject: Re: querying two connections in one query