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

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