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

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

From: Sean Davis <sdavis2(at)mail(dot)nih(dot)gov>
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: [NOVICE] Query with tables from 2 different databases in Java
Date: 2007-06-07 14:25:14
Message-ID: 4668154A.3090105@mail.nih.gov (view raw or flat)
Thread:
Lists: pgsql-jdbcpgsql-novice
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?

Hi, Loredana.  You can't execute a query that includes two different
databases in postgresql.  However, you may want to look at the dblink
contributed module (in contrib/dblink in the postgresql source) that
provides an extension to do this.  I have no idea how this will behave
in the context of a java client, though.

Sean

In response to

Responses

pgsql-novice by date

Next:From: Richard Broersma JrDate: 2007-06-07 14:34:10
Subject: Re: Query with tables from 2 different databases in Java
Previous:From: Tomeh, HusamDate: 2007-06-07 14:21:09
Subject: Re: [NOVICE] Query with tables from 2 different databases in Java

pgsql-jdbc by date

Next:From: Richard Broersma JrDate: 2007-06-07 14:34:10
Subject: Re: Query with tables from 2 different databases in Java
Previous:From: Tomeh, HusamDate: 2007-06-07 14:21:09
Subject: Re: [NOVICE] Query with tables from 2 different databases in Java

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