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 would be 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 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 !
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