Postgres Pro
Downloads
Home   >   mailing lists

Re: Query with tables from 2 different databases in Java - Mailing list pgsql-jdbc

From Mark Lewis
Subject Re: Query with tables from 2 different databases in Java
Date
Msg-id 1181225634.31471.387.camel@archimedes
Whole thread Raw
In response to Query with tables from 2 different databases in Java  ("Loredana Curugiu" <loredana.curugiu@gmail.com>)
Responses Re: Query with tables from 2 different databases in Java  (Richard Broersma Jr <rabroersma@yahoo.com>)
Re: Query with tables from 2 different databases in Java  ("Julius Stroffek" <julo@stroffek.net>)
List pgsql-jdbc
Tree view 
On Thu, 2007-06-07 at 17:08 +0300, Loredana Curugiu wrote:
> Hi,
>
> I need a query to use tables from 2 different databases and
> that query to be executed from a .java file. What do you recommand?
>
> Thanks in advance!
>
>
> Regards,
>        Loredana
>


Move the data to a single database, or else perform the query manually
by pulling back the matching results from each database individually and
then stitching them together.

-- Mark Lewis

pgsql-jdbc by date:

Previous
From: "Loredana Curugiu"
Date:
Subject: Query with tables from 2 different databases in Java
Next
From: Sean Davis
Date:
Subject: Re: [NOVICE] Query with tables from 2 different databases in Java