Re: Conflict between JSON_AGG and COPY

2018-04-09 Thread Đỗ Ngọc Trí Cường
. But it is don't work as I expected with command COPY. Thank you and best regards, Đỗ Ngọc Trí Cường (Mr.) | Software Development Department | +84 28 3715 5325 From: "Adrian Klaver" To: "Đỗ Ngọc Trí Cường" , "pgsql-general" Sent: Monday, April 9, 2018

Conflict between JSON_AGG and COPY

2018-04-07 Thread Đỗ Ngọc Trí Cường
lt I got is quite match what I expect. BQ_BEGIN {"RECORDS":[{"id":1,"username":"john","fullname":"John"},{"id":2,"username":"anna","fullname":"Anna"},{"id":3,"username"