Re: accessing data from other databases? - Mailing list pgsql-novice

From Bruno Wolff III
Subject Re: accessing data from other databases?
Date
Msg-id 20050611023626.GA10569@wolff.to
Whole thread Raw
In response to accessing data from other databases?  ("Celia McInnis" <celia@drmath.ca>)
List pgsql-novice
On Fri, Jun 10, 2005 at 19:57:37 -0500,
  Celia McInnis <celia@drmath.ca> wrote:
>
> ERROR:   cross-database references are not implemented...
>
> I'd rather not combine the databases, since they are huge, and apart from
> this one table which is relevant to both, they are quite independent. I'm
> also not keen on maintaining two copies of the one table which is relevant to
> both, since it will change with time. Are there any other options?

contrib/dblink might be of help. It allows cross database references, but
there are probably some drawbacks that may or may not be a problem in
your specific case.

pgsql-novice by date:

Previous
From: "Sean Davis"
Date:
Subject: Re: accessing data from other databases?
Next
From: "Verena Ruff"
Date:
Subject: Inheritance, foreign key constraint