Received: from druid.net (druid.net [216.126.72.98]) by postgresql.org (Postfix) with ESMTP id DE63347581C for ; Fri, 26 Jul 2002 09:55:09 -0400 (EDT) Received: by druid.net (Postfix, from userid 1000) id 53D921C4E; Fri, 26 Jul 2002 09:55:17 -0400 (EDT) Date: Fri, 26 Jul 2002 09:55:17 -0400 From: "D'Arcy J.M. Cain" To: Reinoud van Leeuwen Cc: pgsql-sql@postgresql.org Subject: Re: Using Tables from another database. Message-ID: <20020726095517.A26474@druid.net> References: <000b01c233e0$3d1b85e0$0301a8c0@infoquest.com.br> Mime-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Disposition: inline Content-Transfer-Encoding: 8bit User-Agent: Mutt/1.2.5.1i In-Reply-To: ; from reinoud.v@n.leeuwen.net on Thu, Jul 25, 2002 at 07:43:30PM +0200 X-Archive-Number: 200207/415 X-Sequence-Number: 8793 * Reinoud van Leeuwen [020726 08:05]: > On Thu, 25 Jul 2002 17:02:44 +0000 (UTC), baldini@infoquest.com.br > (Rogério Baldini das Neves) wrote: > >create view view_test as select * from mydb.mytable; > > This is possible in Sybase or Microsoft SQL server, not in Postgresql > (AFAIK) Yet. It's on the TODO list. -- D'Arcy J.M. Cain | Democracy is three wolves http://www.druid.net/darcy/ | and a sheep voting on +1 416 425 1212 (DoD#0082) (eNTP) | what's for dinner.