Thread: Distributed databases

Hi there!

Is there support for distributed joins on PostgreSQL, that is, can I
create a SELECT statement including data from different database
servers, each one on its own host?


[]s, Fernando Lozano

Le Jeudi 14 Mars 2002 02:03, Fernando Lozano a écrit :
> Is there support for distributed joins on PostgreSQL, that is, can I
> create a SELECT statement including data from different database
> servers, each one on its own hos

This is currently not possible.

On Thu, 14 Mar 2002, Jean-Michel POURE wrote:

> Le Jeudi 14 Mars 2002 02:03, Fernando Lozano a écrit :
> > Is there support for distributed joins on PostgreSQL, that is, can I
> > create a SELECT statement including data from different database
> > servers, each one on its own hos
>
> This is currently not possible.


A temporary solution could be opening two different connections to two
different databases, query seperately and compare them with... PHP, etc.

Best regards,
--

Devrim GUNDUZ

devrim@oper.metu.edu.tr
devrim.gunduz@linux.org.tr
devrimg@tr.net

Web : http://devrim.oper.metu.edu.tr
------------------------------------------------------------------