Re: [NOVICE] Query with tables from 2 different databases inJava

Поиск
Список
Период
Сортировка
От Sean Davis
Тема Re: [NOVICE] Query with tables from 2 different databases inJava
Дата
Msg-id 46682AF8.1040901@mail.nih.gov
обсуждение исходный текст
Ответ на Re: [NOVICE] Query with tables from 2 different databases inJava  ("Loredana Curugiu" <loredana.curugiu@gmail.com>)
Ответы Re: [NOVICE] Query with tables from 2 different databasesinJava
Список pgsql-jdbc
Loredana Curugiu wrote:
>
>
> On 6/7/07, *Bart Degryse* <Bart.Degryse@indicator.be
> <mailto:Bart.Degryse@indicator.be>> wrote:
>
>     Personally I have no good experiences with neither dblink nor dbi-link.
>     They perferm only acceptably on very few records.
>     My approach now is to use srf plperl functions. That approach
>     requires you
>     to have a reasonable knowledge of perl, but is in my experience the
>     fastest
>     (or at least slow) one and certainly the most flexible one.
>
>
> How would you use tables from different databases in the same select
> using perl?

You cannot.  You would need to write a function that does the queries
within it and joins the results within the function.

Sean

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

Предыдущее
От: Richard Broersma Jr
Дата:
Сообщение: Re: [NOVICE] Query with tables from 2 different databases inJava
Следующее
От: "Julius Stroffek"
Дата:
Сообщение: Re: Query with tables from 2 different databases in Java