R: [GENERAL] [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 [EMAIL PROTECTED] ... Probably it would be nice if elephants can fly too ! Best regards, Glauco Mancini -Messaggio originale- Da: Tino Wildenhain [mailto:[EMAIL PROTECTED] 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 ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org
Re: R: [GENERAL] [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 java language. It would be nice if i can use, inside postgresql, something like select * from [EMAIL PROTECTED] ... 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 ---(end of broadcast)--- TIP 6: explain analyze is your friend
[GENERAL] [ODBC] information request on postgresql -- oracle connect via odbc
Hi all, i'm looking for a method to connect natively a postgresql db to oracle ( maybe via odbc ? ) with something similar tothe 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 ? Thanks for your attention, best regards Glauco Mancini
Re: [GENERAL] [ODBC] information request on postgresql -- oracle
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 ? gnari ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster
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 ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org