Re: [GENERAL] Connecting to SQL Server from Windows using FDW

2016-01-23 Thread John J. Turner
> On 23 January 2016 at 04:40, John J. Turner wrote: > On Jan 22, 2016, at 1:05 PM, ivo silvestre wrote: > > > 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 creat

Re: [GENERAL] Connecting to SQL Server from Windows using FDW

2016-01-23 Thread ivo silvestre
Hi John, Thanks, but I already saw that link. The problem is to installing the tds_fwd extension on postgres. And I don't know how to (never tried) compile it... What comes with postgres by default is the postgres fdw , that allow t

Re: [GENERAL] Connecting to SQL Server from Windows using FDW

2016-01-22 Thread John J. Turner
On Jan 22, 2016, at 1:05 PM, ivo silvestre wrote: > 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

Re: [GENERAL] Connecting to SQL Server from Windows using FDW

2016-01-22 Thread Adrian Klaver
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