Postgres Pro
Downloads
Home   >   mailing lists

selects / joins across db's - Mailing list pgsql-general

From james shannon
Subject selects / joins across db's
Date
Msg-id 200012290802.eBT82dL79269@mail.postgresql.org
Whole thread Raw
Responses Re: selects / joins across db's  ("Oliver Elphick" <olly@lfix.co.uk>)
Re: selects / joins across db's  (GH <grasshacker@over-yonder.net>)
List pgsql-general
Tree view 
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@motifstudios.com on 29/12/2000

pgsql-general by date:

Previous
From: "Andrew W. Nosenko"
Date:
Subject: Re: LD_LIBRARY_PATH
Next
From: "Oliver Elphick"
Date:
Subject: Re: selects / joins across db's