Join between tables of two or more databases

Поиск
Список
Период
Сортировка
От T.J. Adami
Тема Join between tables of two or more databases
Дата
Msg-id 1193827666.311111.196410@d55g2000hsg.googlegroups.com
обсуждение исходный текст
Ответы Re: Join between tables of two or more databases  (Reg Me Please <regmeplease@gmail.com>)
Re: Join between tables of two or more databases  (Luca Ferrari <fluca1978@infinito.it>)
Re: Join between tables of two or more databases  ("Pavel Stehule" <pavel.stehule@gmail.com>)
Список pgsql-general
Hi people. I have 2 databases named as follows:

1) company_a

2) company_b


These two databases do not have the same ER model. However, I want to
access tables on "company_a" there are in "company_b". I want to use
them as local tables (as other databases like Sybase allows, since you
have opened a database link).

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?


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

Предыдущее
От: João Paulo Zavanela
Дата:
Сообщение: configure password
Следующее
От: "T.J. Adami"
Дата:
Сообщение: Re: strange message from pg_dumpall