Select to other database's table
Select to other database's table
От:
"yudha" <yudha@BonBon.net>
Дата:
Dear Milist;
Please give me some advices and help. How can i do
"select" the TABLE_1 on other database DB_2,
but currently i'm connecting to on DB_1.
ORACLE :
Current_DB_1 #> Select * From DB_2.TABLE_1;
MS-SQL :
Current_DB_1 #> Select * From DB_2..TABLE_2;
PostGre :
Current_DB_1 #> How do i write...???
GOD Bless You all and TIA.
Re: Select to other database's table
On Thu, 2002-11-28 at 21:21, yudha wrote:
> Dear Milist;
> Please give me some advices and help. How can i do
> "select" the TABLE_1 on other database DB_2,
> but currently i'm connecting to on DB_1.
>
> ORACLE :
> Current_DB_1 #> Select * From DB_2.TABLE_1;
>
> MS-SQL :
> Current_DB_1 #> Select * From DB_2..TABLE_2;
>
> PostGre :
> Current_DB_1 #> How do i write...???
You cannot read from another database. In 7.3, you can have multiple
schemas in one database and the syntax for reading a file from another
schema is:
SELECT * FROM schema.table...
I understand that 7.3's release is imminent.
--
Oliver Elphick Oliver.Elphick@lfix.co.uk
Isle of Wight, UK http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839 932A 614D 4C34 3E1D 0C1C
========================================
"The earth is the LORD'S, and the fullness thereof; the
world, and they that dwell therein." Psalms 24:1