Postgres Pro
Downloads
Home   >   mailing lists

Re: Accessing multiple Databases at the same time - Mailing list pgsql-jdbc

From Nick Fankhauser
Subject Re: Accessing multiple Databases at the same time
Date
Msg-id NEBBLAAHGLEEPCGOBHDGAEBJDJAA.nickf@doxpop.com
Whole thread Raw
In response to Accessing multiple Databases at the same time  ("Lucas, Fred" <fred.lucas@ps.bellhowell.com>)
Responses Re: Re: Accessing multiple Databases at the same time  (Rene Pijlman <rpijlman@wanadoo.nl>)
List pgsql-jdbc
Tree view 
Fred Lucas wrote:
>Is there a way to SELECT tables or create JOINs from multiple databases
>through psql? [...] would this have to be handled programmatically with
>multiple database connections?

Then Rene Pijlman wrote:
>Yes, you need multiple connections for that.

And now Nick writes:
Can you really do this?! that would be great! how is it done? I understand
accessing multiple databases, but I can't figure out how I would do a JOIN
across them.

-Nick


---------------------------------------------------------------------
Nick Fankhauser

    nickf@doxpop.com  Phone 1.765.965.7363  Fax 1.765.962.9788
doxpop - Court records at your fingertips - http://www.doxpop.com/

pgsql-jdbc by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Re: Couple of patches for jdbc driver
Next
From: Peter Wiley
Date:
Subject: Re: Re: JDBC changes for 7.2... some questions...