Paul,
I may be wrong, but I have not found a method of doing so either. On the other hand, look at Oracle's Heterogeneous services to fond out how to connect Oracle to PostGres. Yeah, I know it's backwards, but it may be better than nothing.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
I am looking for procedures on how to connect postgres to an external data source (ODBC to Oracle). I then will query the external data source to write into postgres relations. I can’t find information on how to set up the ODBC connection from postgres to Oracle so I can use SQL in postgres to access data in the Oracle database. I have the Oracle ODBC drivers install and can access them with Excel. I need to also access the database from postgres. Any suggestions on where I can find information on how to make this OBDC connection?
Thanks!
Paul