Received: from u1.abs.net (root@u1.abs.net [207.114.0.131]) by hub.org (8.8.8/8.7.5) with ESMTP id NAA00834 for ; Wed, 27 May 1998 13:03:19 -0400 (EDT) Received: from insightdist.com (nobody@localhost) by u1.abs.net (8.8.5/8.8.5(+AntiRelay)) with UUCP id MAA09532 for pgsql-sql@postgreSQL.org; Wed, 27 May 1998 12:49:29 -0400 (EDT) X-Authentication-Warning: u1.abs.net: nobody set sender to insightdist.com!daveh using -f Received: from ceodev by insightdist.com (AIX 3.2/UCB 5.64/4.03) id AA24081; Wed, 27 May 1998 12:36:53 -0400 Received: from daveh by ceodev (AIX 4.1/UCB 5.64/4.03) id AA53494; Wed, 27 May 1998 12:36:53 -0400 Message-Id: <356C409C.96D485C3@insightdist.com> Date: Wed, 27 May 1998 12:34:37 -0400 From: David Hartwig Organization: Insight Distribution Systems X-Mailer: Mozilla 4.05 [en] (Win95; I) Mime-Version: 1.0 To: Dirk Lutzebaeck Cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] SELECT across two databases References: <13676.9322.689673.963792@gate.wadk-berlin.de> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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