Thread: querying two connections in one query

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.

Regards,

Abdul-Wahid

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

On Mon, Jan 24, 2005 at 02:48:21PM +0000, Abdul-Wahid Paterson wrote:

> Is it possible, perhaps through some extension, to query two database
> through one SQL select statement where the two databases have
> different connections?

contrib/dblink might provide what you're looking for.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/