Re: BUG #14970: Foreign Data Wrapper for windows

From: Michael Paquier <michael(dot)paquier(at)gmail(dot)com>
To: prabakaranbc(at)gmail(dot)com
Cc: PostgreSQL mailing lists <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: BUG #14970: Foreign Data Wrapper for windows
Date: 2017-12-14 00:18:49
Message-ID: CAB7nPqS2Asbj+xog8B8M3pbNGK5QxaraLUSN3cgTB4a0qt7fiw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On Wed, Dec 13, 2017 at 4:45 PM, <prabakaranbc(at)gmail(dot)com> wrote:
> We need to take data from MS SQL database and create views in Postgres.
>
> We could not find any wrapper to support for Windows 32 bit server.

If you look at the wiki page dedicated to FDWs
(https://wiki.postgresql.org/wiki/Foreign_data_wrappers), I can see
that tds_fdw can work with SQL server:
https://github.com/tds-fdw/tds_fdw
It doesn't seem to support windows builds, so it may be better to see
with those folks what's happening.
--
Michael

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2017-12-14 03:39:00 Re: BUG #14952: COPY fails to fill in IDENTITY column default value
Previous Message David G. Johnston 2017-12-13 20:14:52 Re: BUG #14972: row duplicate on first SELECT from CTE (by JOIN/FOR UPDATE) from which UPDATE performed recently