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 [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square, Pennsylvania 19073 ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
