selecting data from multiple DBs

From: "Giovanni Tummarello" <tummarel(at)ascu(dot)unian(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: selecting data from multiple DBs
Date: 2000-11-24 00:32:38
Message-ID: 3A126953000880F0@relay4.inwind.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(at)ascu(dot)unian(dot)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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Kings-Lynne 2000-11-24 01:13:19 RE: [HACKERS] Enum type emulation: problem with opaque type in PL/pgSQL functions
Previous Message Mathieu Arnold 2000-11-23 23:52:16 make check and make installcheck