Postgres Pro
Downloads
Home   >   mailing lists

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

From Loredana Curugiu
Subject Re: [JDBC] Query with tables from 2 different databases inJava
Date
Msg-id 1c23c8e70706070850h7696955aw2bfc8cee38d7b43f@mail.gmail.com
Whole thread Raw
In response to Re: Query with tables from 2 different databases inJava  ("Bart Degryse" <Bart.Degryse@indicator.be>)
Responses Re: [JDBC] Query with tables from 2 different databases inJava
List pgsql-novice
Tree view


On 6/7/07, Bart Degryse <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?


pgsql-novice by date:

Previous
From: "Bart Degryse"
Date:
Subject: Re: Query with tables from 2 different databases inJava
Next
From: Richard Broersma Jr
Date:
Subject: Re: [JDBC] Query with tables from 2 different databases inJava