Re: your mail - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: your mail
Date
Msg-id 200009170258.WAA10645@candle.pha.pa.us
Whole thread Raw
List pgsql-hackers
> Dear Sir/Madam,
> I'm a PhD student at Essex University in UK, doing a research in Distributed
> Database Systems. I would like to ask you some questions:
> I'm using Postgres ver.7, installed in Linux lab which consists of 25
> terminals.
> My actual question is if Postgres provides the functionality to access
> tables which are stored on different hosts using a single Postgres DBMS. For
> instance, let's assume the follwing query:
> 
> select * from A, B where A.num = B.num
> 
> 1- Is it possible to execute this query if the tables A and B are stored
>    on two different machines?

We don't do that.  Sorry.

> 2- Do I need to add something in the Data Catalog, to be able to direct
>    the query into the right host (the one which has the Data).


--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: Alex Sokoloff
Date:
Subject: ascii to character conversion in postgres
Next
From: Peter Eisentraut
Date:
Subject: Re: AW: "setuid" functions, a solution to the RI privilege problem