| From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
|---|---|
| To: | Christos Poulkas <cpoulkas(at)hotmail(dot)com> |
| Cc: | nquiogue(at)ieee(dot)org, pgsql-hackers(at)postgreSQL(dot)org, goran(at)kirra(dot)net, ELOEHR(at)austin(dot)rr(dot)com, dwalker(at)black-oak(dot)com |
| Subject: | Re: your mail |
| Date: | 2000-09-17 02:58:33 |
| Message-ID: | 200009170258.WAA10645@candle.pha.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2000-09-17 10:14:49 | Re: AW: "setuid" functions, a solution to the RI privilege problem |
| Previous Message | Alex Sokoloff | 2000-09-17 02:11:17 | ascii to character conversion in postgres |