Re: your mail

Started by Bruce Momjianover 25 years ago1 messageshackers
Jump to latest
#1Bruce Momjian
bruce@momjian.us

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, Pennsylvania 19026