joining databases - Mailing list pgsql-general

From will trillich
Subject joining databases
Date
Msg-id 20010227180903.A30199@mail.serensoft.com
Whole thread Raw
Responses Re: joining databases  ("Oliver Elphick" <olly@lfix.co.uk>)
Re: joining databases  (Anand Raman <araman@india-today.com>)
List pgsql-general
how can i join separate DATABASES?

    select
        a.fld1,b.fld2
    from
        DBfirst.alphaTable  as a,
        DBsecond.bravoTable as b
    where
        a.xyz = b.pdq
    ;

if not possible, what's the procedure for breaking up tables
across various disk drives for speed optimization?

--
It is always hazardous to ask "Why?" in science, but it is often
interesting to do so just the same.
        -- Isaac Asimov, 'The Genetic Code'

will@serensoft.com
http://groups.yahoo.com/group/newbieDoc -- we need your brain!
http://www.dontUthink.com/ -- your brain needs us!

pgsql-general by date:

Previous
From: will trillich
Date:
Subject: Re: upgrade broke stuff, downgrade still broke
Next
From: will trillich
Date:
Subject: Re: upgrade broke stuff, downgrade still broke