Thread: selecting data from multiple DBs

Hello .. on the same machine i have several DBs.. i owuld like to do a query
that joins results from different ones .. is ther eany way to do it in
postgres? i would expect something list

select foo1 from database1.mytable,database2.mytable etc.. ec.

but i have found no way..

i woudl be very surprised if there was no way to do it.. since Postgres has the
UID concept on any record of any database..
thanks for any info

Sincerley
Giovanni Tummarello
tummarel@ascu.unian.it


Fight Spam! Join CAUCE (Coalition Against Unsolicited Commercial Email)
       at http://www.cauce.org/ and tell your Congresspeople how Spam mailings
       hurt you. Help protect genuine Internet commerce: Outlaw UCE Spamming.

On Fri, Nov 24, 2000 at 01:32:38AM +0100, Giovanni Tummarello wrote:
> Hello .. on the same machine i have several DBs.. i owuld like to do a query
> that joins results from different ones .. is ther eany way to do it in
> postgres?

 It is in the TODO list. Take a look ;)

 Greets.

                                 David