Re: Join between tables of two or more databases

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Join between tables of two or more databases
Дата
Msg-id dcc563d10710310858m28b3435ard1b41ca210be599d@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Join between tables of two or more databases  (Reg Me Please <regmeplease@gmail.com>)
Список pgsql-general
On 10/31/07, Reg Me Please <regmeplease@gmail.com> wrote:
> Il Wednesday 31 October 2007 11:47:46 T.J. Adami ha scritto:

> > The question is: can I do this using remote database servers
> > (different hosts)? If does not, can I do it at least on local
> > databases on the same server?
> >
> As far as they are "different databases", you cannot do it at the moment.
> It doesn't matter whether they are local or not.
> The only option should be to do it at the application level with two
> connections.

Or put the databases into schemas in the same database.  If you need
the join two datasets in pgsql, they need to be in the same database.

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

Предыдущее
От: "Albe Laurenz"
Дата:
Сообщение: Re: Securing stored procedures and triggers
Следующее
От: Reece Hart
Дата:
Сообщение: Re: getting list of tables from command line