Joe Conway wrote: > copyto_json.007.diff
When the source has json fields with non-significant line feeds, the COPY output has these line feeds too, which makes the output incompatible with rule #2 at https://jsonlines.org ("2. Each Line is a Valid JSON Value"). create table j(f json); insert into j values('{"a":1, "b":2 }'); copy j to stdout (format json); Result: {"f":{"a":1, "b":2 }} Is that expected? copy.sgml in 007 doesn't describe the output in terms of lines so it's hard to tell from the doc. Best regards, -- Daniel Vérité https://postgresql.verite.pro/ Twitter: @DanielVerite