Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                

BUG #14116: Character with value 0x0a must be escaped. using COPY FROM - Mailing list pgsql-bugs

From mso1830@gmail.com
Subject BUG #14116: Character with value 0x0a must be escaped. using COPY FROM
Date
Msg-id 20160427080251.18208.4233@wrigleys.postgresql.org
Whole thread Raw
Responses Re: BUG #14116: Character with value 0x0a must be escaped. using COPY FROM
List pgsql-bugs
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..."

pgsql-bugs by date:

Previous
From: Michael Paquier
Date:
Subject: Re: BUG #14109: pg_rewind fails to update target control file in one scenario
Next
From: jsteffee@bepress.com
Date:
Subject: BUG #14117: psql and pg_dump commands should use ENV perl