Received: from hotmail.com (law2-f81.hotmail.com [216.32.181.81]) by hub.org (8.9.3/8.9.3) with SMTP id KAA32952 for ; Thu, 4 Nov 1999 10:37:32 -0500 (EST) (envelope-from dziablo@hotmail.com) Received: (qmail 40199 invoked by uid 0); 4 Nov 1999 15:36:57 -0000 Message-ID: <19991104153657.40198.qmail@hotmail.com> Received: from 207.96.139.139 by www.hotmail.com with HTTP; Thu, 04 Nov 1999 07:36:56 PST X-Originating-IP: [207.96.139.139] From: "Frederic boucher" To: pgsql-sql@postgresql.org Subject: Accessing other database... Date: Thu, 04 Nov 1999 07:36:56 PST Mime-Version: 1.0 Content-Type: text/plain; format=flowed Is it possible to acess another database from a database..? Like SHEMA in oracle? Because, otherwise it meens that all my users should use the same database and see (without being able to select) the others tables, views,etc.. I've tried something like : select * from databasename.tablename; but... it does not work... is there a way around to do this? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com