Accessing multiple Databases at the same time

From: "Lucas, Fred" <fred(dot)lucas(at)ps(dot)bellhowell(dot)com>
To: "'pgsql-jdbc(at)postgresql(dot)org'" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Accessing multiple Databases at the same time
Date: 2001-08-20 22:08:31
Message-ID: 560796A29B821F40A277973FB5EA3004047D68@slexc1a.power.bellhow.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

Hi,
Is there a way to SELECT tables or create JOINs from multiple databases
through psql?
I have read through Mr. Momjian's book and looked at the online
documentation and cannot find a reference to it.

I have been using the "USE" statement in MS SQL Server 7.0.
Is there a similar equivalency in Postgresql or would this have to be
handled programmatically with multiple database connections?

Thanks in advance for any help on this...

Fred Lucas

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Rene Pijlman 2001-08-20 22:57:22 Re: Accessing multiple Databases at the same time
Previous Message Rene Pijlman 2001-08-20 19:48:59 Re: select on multiple tables