Re: Accessing 2 different databases in the same query ?

Поиск
Список
Период
Сортировка
От Richard Huxton
Тема Re: Accessing 2 different databases in the same query ?
Дата
Msg-id 200306020911.36897.dev@archonet.com
обсуждение исходный текст
Ответ на Accessing 2 different databases in the same query ?  (Nagib Abi Fadel <nagib_postgres@yahoo.com>)
Ответы Re: Accessing 2 different databases in the same query ?  (Nagib Abi Fadel <nagib_postgres@yahoo.com>)
Список pgsql-general
On Monday 02 Jun 2003 7:22 am, Nagib Abi Fadel wrote:
> Hi everyone,
>
> Is there a way to access 2 different Tables each one in a different
> database with one sql query ?(or to make references between them)...
>
> Personally i don't believe there's a way because we are talking about two
> different databases, but i'm facing this problem and i would really
> appreciate if anyone could help.

There's a package called "dblink" in the contrib directory of the source
distribution. Might also be available as RPM etc. This sounds like what you
want.

--
  Richard Huxton

В списке pgsql-general по дате отправления:

Предыдущее
От: Richard Huxton
Дата:
Сообщение: Re: sql datatypes storage
Следующее
От: Jean-Michel POURE
Дата:
Сообщение: Re: pgAdmin3 snapshots