Re: connect to another db

From: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: connect to another db
Date: 2005-12-07 16:48:28
Message-ID: 20051207164828.GA3338@kaufbach.delug.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Robert Wimmer <seppwimmer(at)hotmail(dot)com> schrieb:

> 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...

How often du you need this import? Is the different PG db on the same
machine?
At work i have also different PG db's on the same machine, and now i
know i need connections between tables on different db's. Now i have a
new server and i transform old db's to the new server to one db, but
different schemas. I think, this is a good solution.

>
> is the perl solution available on windows ? i think there is no plperl
> installed on windows.

I don't know, i hate windows and don't use this. But i think, plperl are
also available under this OS. But i'm not sure.

> >From: "A. Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com>

Please, no silly top-posting.

HTH, Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message operationsengineer1 2005-12-07 17:35:05 Re: relations in PostgreSQL 8.1
Previous Message Omar Zevallos 2005-12-07 16:36:12 relations in PostgreSQL 8.1