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

Re: Query with tables from 2 different databases in Java

From: Mark Lewis <mark(dot)lewis(at)mir3(dot)com>
To: Loredana Curugiu <loredana(dot)curugiu(at)gmail(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org, pgsql-novice(at)postgresql(dot)org
Subject: Re: Query with tables from 2 different databases in Java
Date: 2007-06-07 14:13:54
Message-ID: 1181225634.31471.387.camel@archimedes (view raw or flat)
Thread:
Lists: pgsql-jdbcpgsql-novice
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

In response to

Responses

pgsql-novice by date

Next:From: Tomeh, HusamDate: 2007-06-07 14:21:09
Subject: Re: [NOVICE] Query with tables from 2 different databases in Java
Previous:From: Loredana CurugiuDate: 2007-06-07 14:08:49
Subject: Query with tables from 2 different databases in Java

pgsql-jdbc by date

Next:From: Tomeh, HusamDate: 2007-06-07 14:21:09
Subject: Re: [NOVICE] Query with tables from 2 different databases in Java
Previous:From: Loredana CurugiuDate: 2007-06-07 14:08:49
Subject: Query with tables from 2 different databases in Java

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