Re: Postgre connect on Postgre

Hi,

Anderson dos Santos Donda wrote:
> Thanks man!!
>
> I'll study this module!!

You should also be aware that sometimes instead of
connecting two separate databases via dblink or similar,
two schemas in one database can be used instead.

It really depends on what you are really doing if
there are even more solutions (like slony for example).

Regards
Tino

PS: the database likes to be called Postgresql or Postgres :-)

> On Tue, Aug 26, 2008 at 11:19 PM, Christophe <xof(at)thebuild(dot)com
> <mailto:xof(at)thebuild(dot)com>> wrote:
>
>
> On Aug 26, 2008, at 7:10 PM, Anderson dos Santos Donda wrote:
>
> How I can connect a postgre database on another postgre
> database, and manipulate the datas on both database?
>
>
> There is a module in contrib just for such a purpose:
>
> http://www.postgresql.org/docs/8.3/interactive/dblink.html
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org
> <mailto:pgsql-general(at)postgresql(dot)org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>