selects / joins across db's

From: james shannon <james(at)motifstudios(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: selects / joins across db's
Date: 2000-12-29 08:02:45
Message-ID: 200012290802.eBT82dL79269@mail.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hello...
i'm trying to join a table from one database with a table from
another database(both from the same server). It seems as if postgres
can't do this.

I don't know what the name of what i'm trying to accomplish is,
but i've seen it done in other databases with 'select * from
corpdb..table, storedb..table where ...'.

Thanks for any help.
-- james shannon, james(at)motifstudios(dot)com on 29/12/2000

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Oliver Elphick 2000-12-29 08:22:39 Re: selects / joins across db's
Previous Message Thomas T. Thai 2000-12-29 04:39:57 regress failed tests.. SERIOUS?