Select to other database's table

From: "yudha" <yudha(at)BonBon(dot)net>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Select to other database's table
Date: 2002-11-28 21:21:00
Message-ID: 008a01c29724$12a78320$ea00a8c0@yudha
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2002-11-29 01:33:43 Re: Starting the database server (2)
Previous Message Bruce Momjian 2002-11-28 20:20:58 Re: Select Multi Database;