Thread: 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 ===