querying two connections in one query

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/

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