How to link database A in server X to database B in server Y?

From: "liu long" <liulong1976(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: How to link database A in server X to database B in server Y?
Date: 2006-05-31 05:30:45
Message-ID: BAY113-F225AB27569FD0C8012045FBC930@phx.gbl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi all,

At the first, please let me say sorry for my poor english.

I have two postgresql database(A and B) running in different machines(X and
Y). I want to visit tables of B from A as if they are tables of A, could
you tell me how can I do?

For example, table t1 belongs to database A, which is located in server X;
table t2 belongs to database B, which is located in server Y.

What I want is : do the below query in database A:
select t1.field1,t2.field2
from t1,t2
where......

Is it possible?
If you have any idea, please let me know.
Thanks in advance.

Best regards,
Long

_________________________________________________________________
与联机的朋友进行交流,请使用 MSN Messenger: http://messenger.msn.com/cn

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Philippe Lang 2006-05-31 05:54:09 Re: Which RPM for RH Linux ES 4? PGDB or RH?
Previous Message A. Kretschmer 2006-05-31 05:04:09 Re: out parameter and setof record