Received: from hub.org.org (localhost [127.0.0.1]) by hub.org (8.10.1/8.11.0) with SMTP id e9S2SRZ40572 for ; Fri, 27 Oct 2000 22:28:27 -0400 (EDT) (envelope-from pgsql-sql-owner@hub.org) Received: from hydra.worlddata.com (hydra.worlddata.com [209.244.192.166]) by hub.org (8.10.1/8.11.0) with ESMTP id e9RL64Z08221 for ; Fri, 27 Oct 2000 17:06:04 -0400 (EDT) (envelope-from sivagami@worlddata.com) Received: from dragon ([209.244.192.67]) by hydra.worlddata.com (Netscape Messaging Server 4.15) with SMTP id G33X6K00.TSY for ; Fri, 27 Oct 2000 17:03:56 -0400 Message-ID: <005901c04059$6a6784d0$43c0f4d1@worlddata.com> From: "Sivagami ." To: Subject: . Date: Fri, 27 Oct 2000 17:03:54 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0056_01C04037.E3482930" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.3018.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.3018.1300 X-Archive-Number: 200010/260 X-Sequence-Number: 1927 This is a multi-part message in MIME format. ------=_NextPart_000_0056_01C04037.E3482930 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi all, I tried: SELECT * FROM DB1.MY_TABLE; from DB2 and it did not like the syntax. I assume that you cannot select a= cross database/schemas. Is this correct? Shiva ------=_NextPart_000_0056_01C04037.E3482930 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Hi all,
 
 
I tried:

SELECT * FROM=20 DB1.MY_TABLE;

from DB2 and it did not like the syntax.  I= =20 assume that you cannot select across database/schemas.

Is this=20 correct?
Shiva
------=_NextPart_000_0056_01C04037.E3482930--