Re: [JDBC] Re: Accessing multiple Databases at the same time

2001-08-23 Thread Rene Pijlman 

[join tables in different databases]
>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.

Apparently you are actually awake when you read this list, I
wasn't :-)

OTOH, if the PostgreSQL engine can do, so can you...

Regards,
René Pijlman

---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster

[JDBC] Re: Accessing multiple Databases at the same time

2001-08-22 Thread Nick Fankhauser 

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

[EMAIL PROTECTED]  Phone 1.765.965.7363  Fax 1.765.962.9788
doxpop - Court records at your fingertips - http://www.doxpop.com/


---(end of broadcast)---
TIP 6: Have you searched our list archives?

http://www.postgresql.org/search.mpl