Postgres Pro
Downloads
Home   >   mailing lists

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

From Michael Fuhr
Subject Re: querying two connections in one query
Date
Msg-id 20050124153529.GA43497@winnie.fuhr.org
Whole thread Raw
In response to querying two connections in one query  (Abdul-Wahid Paterson <abdulwahid@gmail.com>)
List pgsql-general
Tree view 
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/

pgsql-general by date:

Previous
From: Sven Willenberger
Date:
Subject: Re: querying two connections in one query
Next
From: Lonni J Friedman
Date:
Subject: Re: Postgres 8.0 on RHEL