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

From: "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: How to link database A in server X to database B in server Y?
Date: 2006-05-31 05:58:25
Message-ID: 20060531055825.GB24008@webserv.wug-glas.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ===

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lars Haugseth 2006-05-31 06:39:41 Re: Compound words giving undesirable results with tsearch2
Previous Message Philippe Lang 2006-05-31 05:54:09 Re: Which RPM for RH Linux ES 4? PGDB or RH?