The following bug has been logged on the website:
Bug reference: 14116
Logged by: Mohammad alodadi
Email address: mso1830@gmail.com
PostgreSQL version: 9.5.2
Operating system: ubuntu
Description:
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
HQ?**
COPY comments_full, line 1, column comment:
"{"subreddit":"EliteDangerous","controversiality":0,"author_flair_css_class":null,"body":"**Power
Pla..."