Postgres Pro
Downloads
Home   >   mailing lists

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

From Lucas, Fred
Subject Accessing multiple Databases at the same time
Date
Msg-id 560796A29B821F40A277973FB5EA3004047D68@slexc1a.power.bellhow.com
Whole thread Raw
Responses Re: Accessing multiple Databases at the same time  (Rene Pijlman <rpijlman@wanadoo.nl>)
List pgsql-jdbc
Tree view

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

pgsql-jdbc by date:

Previous
From: Rene Pijlman
Date:
Subject: Re: select on multiple tables
Next
From: Rene Pijlman
Date:
Subject: Re: Accessing multiple Databases at the same time