Обсуждение: 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@oracleInstance" ... Probably it wouldbe nice if elephants can fly too ! Best regards, Glauco Mancini -----Messaggio originale----- Da: Tino Wildenhain [mailto:tino@wildenhain.de] Inviato: lunedì 29 maggio 2006 11.50 A: Ragnar Cc: Glauco Mancini; pgsql-general@postgresql.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
Glauco Mancini schrieb: > 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 javalanguage. > > It would be nice if i can use, inside postgresql, something like "select * from myTable@oracleInstance" ... Probably itwould be nice if elephants can fly too ! well if you like the java language but not its footprint, you can also try plpythonu, which is quite similar - syntax wise. if you use dbilink, I think you do not even get in touch with the underlying implementation in perl. So if it isnt the academic approach you are seeking, you should just use it as it is. And it can be used quite similar to what you want above iirc. I guess you already read its documentation? ;-) Regards Tino