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

From: Clemens Ladisch <clemens(at)ladisch(dot)de>
To: pgsql-odbc(at)lists(dot)postgresql(dot)org
Subject: Re: PostgreSQL ODBC Driver to access Oracle/MSSQL from PostgreSQL
Date: 2020-09-01 07:07:38
Message-ID: 8cc40329-b96f-c3ad-63e6-2314aa18288f@ladisch.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-odbc

WAN, RUIWEN wrote:
> Could we use PostgreSQL ODBC Driver to access Oracle/MSSQL database from PostgreSQL?

The psqlODBC driver allows ODBC clients to access Postgres servers.

To allow a Postgres server to access other servers, you need a Foreign Data Wrapper:
<https://wiki.postgresql.org/wiki/Foreign_data_wrappers>

Regards,
Clemens

In response to

Browse pgsql-odbc by date

  From Date Subject
Next Message Rolf Østvik 2020-09-02 07:14:51 RE: PostgreSQL ODBC Driver to access Oracle/MSSQL from PostgreSQL
Previous Message Henrik Krohns 2020-09-01 04:36:48 Re: Crashing with copy_and_convert_field