You can't do cross-db queries directly. In 7.3, you can use schemas and
put them all in the same database, or use /contrib/dblink for cross-db
queries.
---------------------------------------------------------------------------
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...???
>
> GOD Bless You all and TIA.
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
