[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-sql
Subject: [SQL] <database>.<table_name>
From: "Sivagami ." <sivagami () worlddata ! com>
Date: 2000-10-27 21:03:54
[Download RAW message or body]
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
[Attachment #3 (text/html)]
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="MSHTML 5.00.3018.900" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT size=2>Hi all,</FONT></DIV>
<DIV> </DIV>
<DIV> </DIV>
<DIV><FONT size=2>I tried:<BR><BR>SELECT * FROM
DB1.MY_TABLE;<BR><BR>from DB2 and it did not like the syntax. I
assume that you cannot select across database/schemas.<BR><BR>Is this
correct?<BR></DIV></FONT>
<DIV><FONT size=2>Shiva<BR></FONT></DIV></BODY></HTML>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic