From: | "Robert Wimmer" <seppwimmer(at)hotmail(dot)com> |
---|---|
To: | andreas(dot)kretschmer(at)schollglas(dot)com, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: connect to another db |
Date: | 2005-12-07 09:19:10 |
Message-ID: | BAY109-F2EC7D2BDE681EF16756C6D0430@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
hi,
a schema wouldnt help. i have to import data from a different PG db.dblink
would be the right choice, but i think i need a NIX OS to install it ? PG
runs on windows in the company I work for...
is the perl solution available on windows ? i think there is no plperl
installed on windows.
Postgres 8.0
Windows XP Professional
regards and thanks fo the prompt response
>From: "A. Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>
>To: pgsql-novice(at)postgresql(dot)org
>Subject: Re: [NOVICE] connect to another db
>Date: Wed, 7 Dec 2005 09:51:46 +0100
>
>am 07.12.2005, um 8:18:45 +0000 mailte Robert Wimmer folgendes:
> > is there any possibility in plpgsql (or from the psql prompt) to retrive
> > data from any other PG database. if not is there a (recommended) work
> > around for this problem.
>
>You can use dblink (conntrib) or languages like plpgperl to connect to
>multiple db.
>
>http://developer.postgresql.org/cvsweb.cgi/pgsql/contrib/dblink/
>
>
>A better way is to use only one DB and using schemas.
>
>
>HTH, Andreas
>--
>Andreas Kretschmer (Kontakt: siehe Header)
>Heynitz: 035242/47212, D1: 0160/7141639
>GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
> === Schollglas Unternehmensgruppe ===
>
>---------------------------(end of broadcast)---------------------------
>TIP 6: explain analyze is your friend
From | Date | Subject | |
---|---|---|---|
Next Message | Neil Saunders | 2005-12-07 10:48:47 | Re: Coordinates question |
Previous Message | operationsengineer1 | 2005-12-07 09:10:25 | Re: ODBC driver is broken |