Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id D4F8D476206 for ; Wed, 1 May 2002 16:20:40 -0400 (EDT) Received: from mx02.nexgo.de (mx02.nexgo.de [151.189.8.97]) by postgresql.org (Postfix) with ESMTP id AF514475DD0 for ; Wed, 1 May 2002 15:53:05 -0400 (EDT) Received: from mx09.arcor-online.net (mx09.arcor-online.net [151.189.8.85]) by mx02.nexgo.de (Postfix) with ESMTP id 9EE0F9F688 for ; Wed, 1 May 2002 21:53:06 +0200 (CEST) Message-ID: <4590508.1020282786645.JavaMail.ngmail@mx09.arcor-online.net> Date: Wed, 1 May 2002 21:53:06 +0200 (CEST) From: j.konzack@arcor.de To: pgsql-sql@postgresql.org Subject: CREATE VIEW question... Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable X-ngMessageSubType: MessageSubType_MAIL X-WebmailclientIP: : 213.7.177.86, 62.104.208.76 X-Archive-Number: 200205/6 X-Sequence-Number: 7642 Hello there... =20 I have two databases, called db1 an db2. Database db1 contains a table called memberlist. Now I will create a view, called members, in database db2 (containig data from table memberlist) with the following query: =20 CREATE VIEW members AS SELECT * FROM db1.memberlist; =20=20 ->>> this error is displayed: ERROR; parser: error at or near "." =20=20=20 How can I create a view in one database with data from a second/different database? =20=20=20 Jan Konzack ----------------------------------------------------------------------- Riester-Rente - Kassieren Sie das Geld vom Staat: Zum F=F6rderungsrechner! http://www.arcor.de/home/redir.php/riesterrente -----------------------------------------------------------------------