| 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 |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-jdbc pgsql-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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Broersma Jr | 2007-06-07 14:34:10 | Re: Query with tables from 2 different databases in Java |
| Previous Message | Tomeh, Husam | 2007-06-07 14:21:09 | Re: [NOVICE] Query with tables from 2 different databases in Java |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Broersma Jr | 2007-06-07 14:34:10 | Re: Query with tables from 2 different databases in Java |
| Previous Message | Tomeh, Husam | 2007-06-07 14:21:09 | Re: [NOVICE] Query with tables from 2 different databases in Java |