Thread

1. SELECT across two databases

   Dirk Lutzebaeck <lutzeb@cs.tu-berlin.de> — 1998-05-27T14:35:14Z

   hi,
   
   when I have two databases say db1 and db2 can there be a select
   statement which accesses both databases eg.
   
   select * from db1.t1,db2.t2 (which is illegal syntax in postgresql but 
   legal in informix)
   
   Is there another way to select several databases/namespaces at once?
   
   
   Dirk
   
   

2. Re: [SQL] SELECT across two databases

   David Hartwig <daveh@insightdist.com> — 1998-05-27T16:34:37Z

   PostgreSQL does not support this feature at this time.   And, I would not
   expect it any time soon.  You would have to either code such a join by
   hand.
   
   There is one other option.    Many ODBC compliant tools will support
   multi-data source joins.    However this solution may perform poorly
   because one side of the join may iteratively query one of the data
   sources.   Your call.
   
   Irk Lutzebaeck wrote:
   
   > hi,
   >
   > when I have two databases say db1 and db2 can there be a select
   > statement which accesses both databases eg.
   >
   > select * from db1.t1,db2.t2 (which is illegal syntax in postgresql but
   > legal in informix)
   >
   > Is there another way to select several databases/namespaces at once?
   >
   > Dirk