Re: FDW using remote ODBC driver - Mailing list pgsql-general

From Hemil Ruparel
Subject Re: FDW using remote ODBC driver
Date
Msg-id CANW1aT8ruNkvDApk9OSfnmwJqpGcKArZaX0oHaeggMjVy+O3tQ@mail.gmail.com
Whole thread Raw
In response to FDW using remote ODBC driver  ("Zwettler Markus (OIZ)" <Markus.Zwettler@zuerich.ch>)
Responses AW: FDW using remote ODBC driver  ("Zwettler Markus (OIZ)" <Markus.Zwettler@zuerich.ch>)
List pgsql-general
Yes. The driver needs to be on the client

On Tue, Dec 1, 2020 at 8:34 PM Zwettler Markus (OIZ) <Markus.Zwettler@zuerich.ch> wrote:

Hi,

 

Can I create a FDW connection using an ODBC driver which is installed on a remote host, e.g.

 

Postgres@Linux è FDW è ODBC@Windows è SQL-Server

 

In other words, must the ODBC driver be installed on the local Linux system?

 

Thanks,

Markus

 

pgsql-general by date:

Previous
From: "Zwettler Markus (OIZ)"
Date:
Subject: FDW using remote ODBC driver
Next
From: mobigroup
Date:
Subject: Re: PostgreSQL 12.4 Parallel Query doesn't work while EXPLAIN is OK