Thread: access multiple PostgreSQL Databases at the same time.

access multiple PostgreSQL Databases at the same time.

From
Louie Kwan
Date:
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
>

Re: access multiple PostgreSQL Databases at the same time.

From
Andrew Sullivan
Date:
On Wed, Mar 24, 2004 at 03:09:21PM -0500, Louie Kwan wrote:
> 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.

Doesn't seem like much security if you're going to break it by
putting a back door in.  But there's a contrib module called dblink
that will likely help you.

A

--
Andrew Sullivan  | ajs@crankycanuck.ca
The plural of anecdote is not data.
        --Roger Brinner