Distributed databases

Started by Fernando Lozanoabout 24 years ago3 messagesgeneral
Jump to latest
#1Fernando Lozano
fsl@centroin.com.br

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

#2Jean-Michel POURE
jm.poure@freesurf.fr
In reply to: Fernando Lozano (#1)
Re: Distributed databases

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.

#3Devrim GUNDUZ
devrim@oper.metu.edu.tr
In reply to: Jean-Michel POURE (#2)
Re: Distributed databases

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
------------------------------------------------------------------