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