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@oracleInstance" ... Probably it would be nice if elephants can fly too ! Best regards, Glauco Mancini -----Messaggio originale----- Da: Tino Wildenhain [mailto:tino@xxxxxxxxxxxxx] Inviato: lunedì 29 maggio 2006 11.50 A: Ragnar Cc: Glauco Mancini; pgsql-general@xxxxxxxxxxxxxx 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
