> 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