| From: | Sean Davis <sdavis2(at)mail(dot)nih(dot)gov> |
|---|---|
| To: | Loredana Curugiu <loredana(dot)curugiu(at)gmail(dot)com> |
| Cc: | Bart(dot)Degryse(at)indicator(dot)be, pgsql-novice(at)postgresql(dot)org, pgsql-jdbc(at)postgresql(dot)org |
| Subject: | Re: [NOVICE] Query with tables from 2 different databases inJava |
| Date: | 2007-06-07 15:57:44 |
| Message-ID: | 46682AF8.1040901@mail.nih.gov |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc pgsql-novice |
Loredana Curugiu wrote:
>
>
> On 6/7/07, *Bart Degryse* <Bart(dot)Degryse(at)indicator(dot)be
> <mailto:Bart(dot)Degryse(at)indicator(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Srinivas Kotapally | 2007-06-07 22:21:58 | Intermittent Connection problems using JDBC |
| Previous Message | Richard Broersma Jr | 2007-06-07 15:51:08 | Re: [NOVICE] Query with tables from 2 different databases inJava |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lonni J Friedman | 2007-06-07 18:42:56 | querying the age of a row |
| Previous Message | Richard Broersma Jr | 2007-06-07 15:51:08 | Re: [NOVICE] Query with tables from 2 different databases inJava |