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

From Andrew Sullivan
Subject Re: access multiple PostgreSQL Databases at the same time.
Date
Msg-id 20040324201910.GA16800@phlogiston.dyndns.org
Whole thread Raw
In response to access multiple PostgreSQL Databases at the same time.  (Louie Kwan <lkwan@nuvo.com>)
List pgsql-admin
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

pgsql-admin by date:

Previous
From: Louie Kwan
Date:
Subject: access multiple PostgreSQL Databases at the same time.
Next
From: Tom Lane
Date:
Subject: Re: [Retrieved]RE: backup and recovery