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.
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 |