Select between two databases

Поиск
Список
Период
Сортировка
От Indraneel Majumdar
Тема Select between two databases
Дата
Msg-id Pine.SGI.3.96.1000924171306.91135C-100000@www.cdfd.org.in
обсуждение исходный текст
Ответы Re: Select between two databases  (Stephan Szabo <sszabo@megazone23.bigpanda.com>)
Список pgsql-sql
Hi,

Does any one know how I may select between two databases running on same
machine or on different machines eg.

select colA1 from tableA1 where colA2 in (select colB1 from tableB1);

here tableA1 and tableB1 are in different databases. The two databases
might be under the same postmaster or on different machines under
different postmasters. How do I query both simultaneously? Is it possible?

Thanks,
Indraneel

/************************************************************************.
# Indraneel Majumdar                  ¡  E-mail: indraneel@123india.com  #
# Bioinformatics Unit (EMBNET node),  ¡  URL: http://scorpius.iwarp.com  #
# Centre for DNA Fingerprinting and Diagnostics,                         #
# Hyderabad, India - 500076                                              #
`************************************************************************/



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

Предыдущее
От: Philip Warner
Дата:
Сообщение: RFC - change of behaviour of pg_get_userbyid & pg_get_viewdef?
Следующее
От: Fredrick Bartlett
Дата:
Сообщение: Re: Select between two databases