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

Поиск
Список
Период
Сортировка
От A. Kretschmer
Тема Re: How to link database A in server X to database B in server Y?
Дата
Msg-id 20060531055825.GB24008@webserv.wug-glas.de
обсуждение исходный текст
Ответ на How to link database A in server X to database B in server Y?  ("liu long" <liulong1976@hotmail.com>)
Список pgsql-general
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    ===

В списке pgsql-general по дате отправления:

Предыдущее
От: "Philippe Lang"
Дата:
Сообщение: Re: Which RPM for RH Linux ES 4? PGDB or RH?
Следующее
От: Lars Haugseth
Дата:
Сообщение: Re: Compound words giving undesirable results with tsearch2