R: [ODBC] information request on postgresql --> oracle

Hi all,

Ragnar and Tino many thanks for you feedback.

Using this type of approach probably i will try first with pl-j or pl/java because i am more comfortable with the java language.

It would be nice if i can use, inside postgresql, something like "select * from myTable(at)oracleInstance" ... Probably it would be nice if elephants can fly too !

Best regards,

Glauco Mancini

-----Messaggio originale-----
Da: Tino Wildenhain [mailto:tino(at)wildenhain(dot)de]
Inviato: lunedì 29 maggio 2006 11.50
A: Ragnar
Cc: Glauco Mancini; pgsql-general(at)postgresql(dot)org
Oggetto: Re: [GENERAL] [ODBC] information request on postgresql --> oracle

Ragnar schrieb:
> On mán, 2006-05-29 at 10:21 +0200, Glauco Mancini wrote:
>
>
>>i'm looking for a method to connect natively a postgresql db to oracle
>>( maybe via odbc ? ) with something similar to the oracle dblink.
>>
>>I connected successfully a oracle instance to a postgresql instance
>>using unix-odbc, now i need to proceed on the other way.
>>
>>Can you please help me with some suggestion ?
>
>
> maybe plperlu and DBD::Oracle ?
>
Or easier: http://pgfoundry.org/projects/dbi-link/

Which uses that approach imho.

Regards
Tino