Re: querying two connections in one query

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Abdul-Wahid Paterson <abdulwahid(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: querying two connections in one query
Date: 2005-01-24 15:35:29
Message-ID: 20050124153529.GA43497@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sven Willenberger 2005-01-24 15:36:22 Re: querying two connections in one query
Previous Message Rick Schumeyer 2005-01-24 15:25:09 Postgres 8.0 on RHEL