Re: [NOVICE] Query with tables from 2 different databases inJava - Mailing list pgsql-jdbc

From Sean Davis
Subject Re: [NOVICE] Query with tables from 2 different databases inJava
Date
Msg-id 46682AF8.1040901@mail.nih.gov
Whole thread Raw
In response to Re: [NOVICE] Query with tables from 2 different databases inJava  ("Loredana Curugiu" <loredana.curugiu@gmail.com>)
Responses Re: [NOVICE] Query with tables from 2 different databasesinJava  ("Bart Degryse" <Bart.Degryse@indicator.be>)
List 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 by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: [NOVICE] Query with tables from 2 different databases inJava
Next
From: "Julius Stroffek"
Date:
Subject: Re: Query with tables from 2 different databases in Java