Re: accessing data from other databases?

Поиск
Список
Период
Сортировка
От Bruno Wolff III
Тема Re: accessing data from other databases?
Дата
Msg-id 20050611023626.GA10569@wolff.to
обсуждение исходный текст
Ответ на accessing data from other databases?  ("Celia McInnis" <celia@drmath.ca>)
Список 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 по дате отправления:

Предыдущее
От: "Sean Davis"
Дата:
Сообщение: Re: accessing data from other databases?
Следующее
От: "Verena Ruff"
Дата:
Сообщение: Inheritance, foreign key constraint