Обсуждение: How to link database A in server X to database B in server Y?

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

am  31.05.2006, um  5:30:45 +0000 mailte liu long folgendes:
> 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?

dblink.

07:57 < akretschmer> ??dblink
07:57 < rtfm_please> For information about dblink
07:57 < rtfm_please> see http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/dblink/
07:57 < rtfm_please> or http://pgfoundry.org/projects/dblink-tds/


HTH, Andreas
--
Andreas Kretschmer    (Kontakt: siehe Header)
Heynitz:  035242/47215,      D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
 ===    Schollglas Unternehmensgruppe    ===