Received: from camel8.mindspring.com (camel8.mindspring.com [207.69.200.58]) by hub.org (8.9.2/8.9.1) with ESMTP id UAA63981 for ; Thu, 25 Feb 1999 20:24:59 -0500 (EST) (envelope-from clark.evans@manhattanproject.com) Received: from manhattanproject.com (pool-207-205-162-7.nwrk.grid.net [207.205.162.7]) by camel8.mindspring.com (8.8.5/8.8.5) with ESMTP id UAA27220 for ; Thu, 25 Feb 1999 20:24:58 -0500 (EST) Sender: clark@mindspring.com Message-ID: <36D5F714.7637EC70@manhattanproject.com> Date: Fri, 26 Feb 1999 01:21:24 +0000 From: Clark Evans X-Mailer: Mozilla 4.5 [en] (X11; U; Linux 2.0.36 i686) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgreSQL.org Subject: Schema / Database SELECT support? References: <199902251416.JAA22638@m1p17-235.waterauthority.state.fl.us> <36D5F0F0.A49429A@manhattanproject.com> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit I tried: SELECT * FROM DB_A.MY_TABLE; from DB_B and it did not like the syntax. I assume that you cannot select across database/schemas. Is this correct? :) Clark Evans