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 >

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] DISTINCT in STRING_AGG

2015-11-28 Thread John J. Turner
On Nov 28, 2015, at 1:35 PM, Sterpu Victor wrote: > Hello > > Can I make a distinct STRING_AGG? > This is my query : > SELECT atjs.id, STRING_AGG(CAST(aqjs1.id AS VARCHAR), ',' ORDER BY > aqjs1.to_left) AS children > FROM administration.ad_query_join_select atjs > JOIN administration.ad_query

Re: [GENERAL] How can I change defined schema of linked tables when using Access linked table manager odbc connection

2015-10-29 Thread John J. Turner
On Oct 29, 2015, at 6:14 AM, Killian Driscoll wrote: > I am using postgresql 9.3 on Windows 8 64, and am using Access as a frontend > data entry. In postgresql I have changed the schema from 'public' to 'irll'. > The linked table in Access are still linked as 'public' and I need to > update/cha