> 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 [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026