RE: PostgreSQL ODBC Driver to access Oracle/MSSQL from PostgreSQL

Database ODBC drivers is used the other way around. PostgreSQL ODBC driver is for accessing a PostgreSQL database from other applications.

I think foreign data wrappers is what you want. I have planned to do the same as you, but have not implemented or tested anything yet.
https://wiki.postgresql.org/wiki/Foreign_data_wrappers

Best regards,
Rolf Østvik

From: WAN, RUIWEN <rx152u(at)att(dot)com>
Sent: mandag 31. august 2020 23:50
To: pgsql-odbc(at)postgresql(dot)org
Subject: PostgreSQL ODBC Driver to access Oracle/MSSQL from PostgreSQL

To whom it will concern,

We are trying to access Oracle/MSSQL database from PostgreSQL, PostgreSQL ODBC Driver comes across.

Could we use PostgreSQL ODBC Driver to access Oracle/MSSQL database from PostgreSQL?

If the answer is yes, how? Could you share documents on how to access?

Thanks,
Ruiwen Wan
Principal Member of Tech Staff
Network Cloud & Infrastructure

AT&T Services, Inc
200 S LAUREL AVE BLDG A, E3-3D22, MIDDLETOWN, NJ 07748
o 732.420.0469 | m 732.299.6618 | ruiwen(dot)xu(at)att(dot)com<mailto:ruiwen(dot)xu(at)att(dot)com>