Postgres Pro
Downloads
Home   >   mailing lists

Thread: Select to other database's table

Select to other database's table

From
"yudha"
Date:
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

From
Oliver Elphick
Date:
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
Attachment