access multiple PostgreSQL Databases at the same time. - Mailing list pgsql-admin

From Louie Kwan
Subject access multiple PostgreSQL Databases at the same time.
Date
Msg-id FB4FDC17A002D711BC0C009027DE84AF027F6C72@EXCHANGE.nuvo.com
Whole thread Raw
Responses Re: access multiple PostgreSQL Databases at the same time.  (Andrew Sullivan <ajs@crankycanuck.ca>)
List pgsql-admin
Hi All,

Due to some security issues, we need to separate the data for one customer
into a separate PostgreSQL box/server.

My question is that how could we have sql statements which allow us to
access multiple PostgreSQL databases at the same time. Not separate schema,
but in different postgresql server.

Is there a way to SELECT tables or create JOINs from multiple databases JDBC
or psql . I aware that Oracle has Database Link concept.

Any tip will help. I did some search on previous posting, but cannot find
much.

Louie Kwan
> NUVO - THE IT OUT-TASKING COMPANY
> (613) 726-5071        Direct Line
> (613) 721-1399     Fax
>

pgsql-admin by date:

Previous
From: Naomi Walker
Date:
Subject: Re: [Retrieved]RE: backup and recovery
Next
From: Andrew Sullivan
Date:
Subject: Re: access multiple PostgreSQL Databases at the same time.