Re: BUG #14116: Character with value 0x0a must be escaped. using COPY FROM

On Wed, Apr 27, 2016 at 10:02 AM,  <mso1830@gmail.com> wrote:
> I tried to inserte large json rows from text file into postgres DB. however,
> there is error message says:
> ERROR:  invalid input syntax for type json
> DETAIL:  Character with value 0x0a must be escaped.
> CONTEXT:  JSON data, line 1: ...at is closer rather than farther from the

Seems right, all the json documents I have read say, more or less "A
string is a sequence of Unicode code points wrapped with quotation
marks (U+0022). All characters may be placed within the quotation
marks except for the characters that must be escaped: quotation mark
(U+0022), reverse solidus (U+005C), and the control characters U+0000
to U+001F."  ( Copied from
http://www.ecma-international.org/publications/files/ECMA-ST/ECMA-404.pdf,
which may not be the correct one but seems right for me ).

In fact, noneof the software I presently use to read or generate json
does accept OR PRODUCE unescaped 0x0A. Are you generating the json
manually?

Francisco Olarte.