Home > mailing lists

Select to other database's table - Mailing list pgsql-admin

From	yudha
Subject	Select to other database's table
Date	November 28, 2002 04:24:59
Msg-id	008a01c29724$12a78320$ea00a8c0@yudha Whole thread Raw
Responses	Re: Select to other database's table
List	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.

From: Oliver Elphick
Date: 27 November 2002, 19:13:28
Subject: Re: Problems invoking psql, was: Re: Troubles at

From: Oliver Elphick
Date: 28 November 2002, 05:21:57
Subject: Re: Select to other database's table