Re: R: [ODBC] information request on postgresql --> oracle - Mailing list pgsql-general

From Tino Wildenhain
Subject Re: R: [ODBC] information request on postgresql --> oracle
Date
Msg-id 447C1FF6.4060806@wildenhain.de
Whole thread Raw
In response to R: [ODBC] information request on postgresql --> oracle  ("Glauco Mancini" <mancini@tiscali.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Glauco Mancini"
Date:
Subject: R: [ODBC] information request on postgresql --> oracle
Next
From: "Rafael Martinez, Guerrero"
Date:
Subject: 8.1.4 - problem with PITR - .backup.done / backup.ready version of the same file at the same time.