Received: from localhost.localdomain (postgresql.org [64.49.215.8]) by localhost (Postfix) with ESMTP id 5F855476260 for ; Wed, 1 May 2002 17:25:56 -0400 (EDT) Received: from anchor-post-33.mail.demon.net (anchor-post-33.mail.demon.net [194.217.242.91]) by postgresql.org (Postfix) with ESMTP id AD147475AA1 for ; Wed, 1 May 2002 16:51:13 -0400 (EDT) Received: from lfix.demon.co.uk ([158.152.59.127] helo=linda.lfix.co.uk) by anchor-post-33.mail.demon.net with esmtp (Exim 3.35 #1) id 17314E-000AfV-0X; Wed, 01 May 2002 21:51:14 +0100 Received: from localhost ([127.0.0.1] helo=localhost.localdomain ident=olly) by linda.lfix.co.uk with esmtp (Exim 3.35 #1 (Debian)) id 17314R-0004sI-00; Wed, 01 May 2002 21:51:27 +0100 Subject: Re: CREATE VIEW question... From: Oliver Elphick To: j.konzack@arcor.de Cc: pgsql-sql@postgresql.org In-Reply-To: <4590508.1020282786645.JavaMail.ngmail@mx09.arcor-online.net> References: <4590508.1020282786645.JavaMail.ngmail@mx09.arcor-online.net> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-SEcFEVNBpPU1S7iru/np" X-Mailer: Ximian Evolution 1.0.3 Date: 01 May 2002 21:51:27 +0100 Message-Id: <1020286287.16880.190.camel@linda> Mime-Version: 1.0 X-Archive-Number: 200205/7 X-Sequence-Number: 7643 --=-SEcFEVNBpPU1S7iru/np Content-Type: text/plain Content-Transfer-Encoding: quoted-printable On Wed, 2002-05-01 at 20:53, j.konzack@arcor.de wrote: =20 > CREATE VIEW members AS SELECT * FROM db1.memberlist; >=20=20=20 > ->>> this error is displayed: ERROR; parser: error at or near "." >=20=20=20=20 > How can I create a view in one database with data from a second/different > database? You cannot. When 7.3 comes out, you could implement this as separate schemas within one database. --=20 Oliver Elphick Oliver.Elphick@lfix.co.uk Isle of Wight http://www.lfix.co.uk/oliver GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C "For if ye forgive men their trespasses, your heavenly=20 Father will also forgive you; But if ye forgive not=20 men their trespasses, neither will your Father forgive your trespasses." Matthew 6:14,15=20 --=-SEcFEVNBpPU1S7iru/np Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQA80FVOYU1MND4dDBwRAl0uAKDBb3j/u36u216TVmkrb+ZEbDXJjgCgjcv8 pO1MR4cP4Trqw/yCJQ0vONo= =ZC+R -----END PGP SIGNATURE----- --=-SEcFEVNBpPU1S7iru/np--