ERROR: parser: parse error at or near "."<= /DIV>

Whats the problem??

How can I solve this problem?

Thanks a lot,

Rog=E9rio Baldini

------=_NextPart_000_0007_01C233C7.16DBB080-- From oomoomi@hotmail.com Thu Jul 25 17:32:47 2002 Received: from hotmail.com (f260.law14.hotmail.com [64.4.20.135]) by postgresql.org (Postfix) with ESMTP id 49FED475CAE for ; Thu, 25 Jul 2002 13:32:47 -0400 (EDT) Received: from mail pickup service by hotmail.com with Microsoft SMTPSVC; Thu, 25 Jul 2002 10:32:45 -0700 Received: from 213.29.16.6 by lw14fd.law14.hotmail.msn.com with HTTP; Thu, 25 Jul 2002 17:32:45 GMT X-Originating-IP: [213.29.16.6] From: "omid omoomi" To: pgsql-sql@postgresql.org Subject: Re: Using Tables from another database. Date: Thu, 25 Jul 2002 17:32:45 +0000 Mime-Version: 1.0 Content-Type: text/plain; format=flowed Message-ID: X-OriginalArrivalTime: 25 Jul 2002 17:32:45.0588 (UTC) FILETIME=[49B31540:01C23401] X-Archive-Number: 200207/407 X-Sequence-Number: 8785 hi, You may simply write: create view view_test as select * from mytable; But if the your table is in another database, then I am sorry. no way. regards Omid Omoomi >From: Rogério Baldini das Neves >To: >Subject: [SQL] Using Tables from another database. >Date: Thu, 25 Jul 2002 10:36:09 -0300 > >Hello, > >I need to make a view like: > >create view view_test as select * from mydb.mytable; > >and I get this error: > >ERROR: parser: parse error at or near "." > >Whats the problem?? > >How can I solve this problem? > >Thanks a lot, > >Rogério Baldini > > _________________________________________________________________ Send and receive Hotmail on your mobile device: http://mobile.msn.com From bruno@wolff.to Thu Jul 25 17:30:27 2002 Received: from wolff.to (wolff.to [66.92.219.49]) by postgresql.org (Postfix) with SMTP id B234747546E for ; Thu, 25 Jul 2002 13:30:27 -0400 (EDT) Received: (qmail 6602 invoked by uid 500); 25 Jul 2002 17:36:32 -0000 Date: Thu, 25 Jul 2002 12:36:32 -0500 From: Bruno Wolff III To: =?iso-8859-1?Q?Rog=E9rio?= Baldini das Neves Cc: pgsql-sql@postgresql.org Subject: Re: Using Tables from another database. Message-ID: <20020725173632.GA6588@wolff.to> Mail-Followup-To: =?iso-8859-1?Q?Rog=E9rio?= Baldini das Neves , pgsql-sql@postgresql.org 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 In-Reply-To: <000b01c233e0$3d1b85e0$0301a8c0@infoquest.com.br> User-Agent: Mutt/1.3.25i X-Archive-Number: 200207/406 X-Sequence-Number: 8784 On Thu, Jul 25, 2002 at 10:36:09 -0300, Rogério Baldini das Neves wrote: > > How can I solve this problem? The simplest answer is to pick a name that doesn't have a period in it. If you are really trying to use schemas, you have to wait for 7.3. From reinoud.v@n.leeuwen.net Thu Jul 25 17:44:14 2002 Received: from news.hub.org (news.hub.org [64.49.215.80]) by postgresql.org (Postfix) with ESMTP id 1271A475481 for ; Thu, 25 Jul 2002 13:44:14 -0400 (EDT) Received: by news.hub.org (Postfix, from userid 8) id D37713824E2; Thu, 25 Jul 2002 13:43:51 -0400 (EDT) From: Reinoud van Leeuwen X-Newsgroups: comp.databases.postgresql.sql Subject: Re: Using Tables from another database. Date: Thu, 25 Jul 2002 19:43:30 +0200 Organization: Not organized in any way Lines: 23 Message-ID: References: <000b01c233e0$3d1b85e0$0301a8c0@infoquest.com.br> Reply-To: reinoud.v@n.leeuwen.net Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Complaints-To: abuse@xs4all.nl X-Newsreader: Forte Agent 1.9/32.560 To: pgsql-sql@postgresql.org X-Archive-Number: 200207/410 X-Sequence-Number: 8788 On Thu, 25 Jul 2002 17:02:44 +0000 (UTC), baldini@infoquest.com.br (Rogério Baldini das Neves) wrote: >Hello, > >I need to make a view like: > >create view view_test as select * from mydb.mytable; > >and I get this error: > >ERROR: parser: parse error at or near "." > >Whats the problem?? This is possible in Sybase or Microsoft SQL server, not in Postgresql (AFAIK) -- __________________________________________________ "Nothing is as subjective as reality" Reinoud van Leeuwen reinoud.v@n.leeuwen.net http://www.xs4all.nl/~reinoud From darcy@druid.net Fri Jul 26 13:55:09 2002 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.