Skip site navigation (1) Skip section navigation (2)

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

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 (view raw or flat)
Thread:
Lists: pgsql-jdbcpgsql-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

In response to

Responses

pgsql-novice by date

Next:From: Lonni J FriedmanDate: 2007-06-07 18:42:56
Subject: querying the age of a row
Previous:From: Richard Broersma JrDate: 2007-06-07 15:51:08
Subject: Re: [NOVICE] Query with tables from 2 different databases inJava

pgsql-jdbc by date

Next:From: Srinivas KotapallyDate: 2007-06-07 22:21:58
Subject: Intermittent Connection problems using JDBC
Previous:From: Richard Broersma JrDate: 2007-06-07 15:51:08
Subject: Re: [NOVICE] Query with tables from 2 different databases inJava

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group