Re: accessing two databases at the same time

Поиск
Список
Период
Сортировка
От Tariq Muhammad
Тема Re: accessing two databases at the same time
Дата
Msg-id Pine.LNX.4.21.0303051608080.19659-100000@genesis.int.libertyrms.com
обсуждение исходный текст
Ответ на accessing two databases at the same time  (Peter Choe <choepete@mindspring.com>)
Ответы Re: accessing two databases at the same time
Список pgsql-general
Дерево обсуждения 
On Wed, 5 Mar 2003, Peter Choe wrote:

> if i have database 'A' with a table called 'a' and another database 'B'
> with a table called 'b', is there a way to do a select using both databases
> and their tables?
>
> select * from A.a, B.b;
>

You may wanna have a look at dblink under contrib.

     _/_/     _/_/    _/_/  Tariq Muhammad
    _/  _/  _/   _/ _/  _/  tariq@libertyrms.info
   _/   _/ _/_/_/  _/_/_/   v:416-646-3304 x 111
  _/   _/ _/   _/ _/  _/    c:416-455-0272
 _/_/_/  _/_/_/  _/  _/     p:416-381-1457
_________________________________________________
     Liberty Registry Management Services Co.

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