Received: from mail.unlisys.net (root@mail.unlisys.net [195.21.255.252]) by hub.org (8.8.8/8.7.5) with SMTP id KAA27778 for ; Wed, 27 May 1998 10:35:11 -0400 (EDT) Received: by mail.unlisys.net (Smail3.2.0.96inx) from gate.wadk-berlin.de (195.21.185.177) with esmtp id ; Wed, 27 May 1998 16:35:09 +0200 (MET DST) Received: (from lutzeb@localhost) by gate.wadk-berlin.de (8.8.7/8.8.5) id QAA03345; Wed, 27 May 1998 16:35:14 +0200 X-Authentication-Warning: gate.wadk-berlin.de: lutzeb set sender to lutzeb@ using -f From: Dirk Lutzebaeck MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Date: Wed, 27 May 1998 16:35:14 +0200 (MEST) To: pgsql-sql@postgresql.org Subject: SELECT across two databases X-Mailer: VM 6.43 under 20.4 "Emerald" XEmacs Lucid Message-ID: <13676.9322.689673.963792@gate.wadk-berlin.de> X-Face: K?6k:xO"sj7_T|{X)A`r]6[I.H"<4/_nRj{n'n<4X,iC%Dd*8y1; IH'LSWu!.,a(gAToSQd HFA,|S@:/?%xa"e!VnTGLwv; s}E[%p$eh)p./sOdd=kuGo0FV-_E+nvaxIWW&@w:9wo[rm5A$OaJ:OI@~$#9q7Z+F@oaKKZl3<"<]wP/'xDm{\Q_, qPy< /dr8[rj"|&k`>07{eQ.#*\MfLT/eMhk!G$lZMN#_@_AbvIq9r!ds 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