On 01/22/2016 10:05 AM, ivo silvestre wrote:
Hi, I need to create a linked server between 2 Windows servers. In one I've PostgreSQL with admin privileges and in the other MS SQL with only read access. I need to create a view (or a foreign table?) in PostgreSQL from a table in MS SQL in another server. The table in the MS SQL is constantly growing and I need on-the-fly access to the data. After some web search I found GeoffMontee's Github, but I don't know how to install it on Windows... Is there anyone how already did something like this and could help me out..?
Seems like it is an open issue: https://github.com/GeoffMontee/tds_fdw/issues/53
Thanks in advance! Kind regards, -- Ivo Silvestre ______________________ *técnico sig | gis technician* <https://www.linkedin.com/in/ivomts> ______________________
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general