Ask about Foreign Table Plug-in on Windows Server.

Started by Anuwat Sagulmontreechaiover 2 years ago3 messagesgeneral
Jump to latest
#1Anuwat Sagulmontreechai
anuwat_s@softsquaregroup.com

Hi PG Support Team,

Our customer install PG on Windows Server 2022 and need to use Foreign Table to connect to SQL Server on WS2022 too, so we tried to find the plug-in but unfortunately we found only Linux version. Could you please advise us?

Thank you in advance for your help.

Best Regards,
Anuwat Sagulmontreechai (Max)
Soft Square Group of Companies
Tel. 02-997-2000 ext.2305

#2Laurenz Albe
laurenz.albe@cybertec.at
In reply to: Anuwat Sagulmontreechai (#1)
Re: Ask about Foreign Table Plug-in on Windows Server.

On Thu, 2023-10-05 at 10:39 +0000, Anuwat Sagulmontreechai wrote:

Our customer install PG on Windows Server 2022 and need to use Foreign Table to connect
to SQL Server on WS2022 too, so we tried to find the plug-in but unfortunately we found
only Linux version. Could you please advise us?

There are no official releases of tds_fdw for Windows. But in this issue
(https://github.com/tds-fdw/tds_fdw/issues/53) somebody claims to have build the
extension on Windows. You could try the same.

Yours,
Laurenz Albe

#3Anuwat Sagulmontreechai
anuwat_s@softsquaregroup.com
In reply to: Laurenz Albe (#2)
RE: Ask about Foreign Table Plug-in on Windows Server.

Tyvvm, will try

Best Regards,
Anuwat Sagulmontreechai (Max)
Soft Square Group of Companies
Tel. 02-997-2000 ext.2305

-----Original Message-----
From: Laurenz Albe <laurenz.albe@cybertec.at>
Sent: Friday, October 6, 2023 2:43 AM
To: Anuwat Sagulmontreechai <anuwat_s@softsquaregroup.com>; pgsql-general@lists.postgresql.org
Cc: jakarin_a@softsquaregroup.com; phasit_s@softsquaregroup.com
Subject: Re: Ask about Foreign Table Plug-in on Windows Server.

On Thu, 2023-10-05 at 10:39 +0000, Anuwat Sagulmontreechai wrote:

Our customer install PG on Windows Server 2022 and need to use Foreign
Table to connect to SQL Server on WS2022 too, so we tried to find the
plug-in but unfortunately we found only Linux version. Could you please advise us?

There are no official releases of tds_fdw for Windows. But in this issue
(https://github.com/tds-fdw/tds_fdw/issues/53) somebody claims to have build the extension on Windows. You could try the same.

Yours,
Laurenz Albe