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

Поиск
Список
Период
Сортировка
От mso1830@gmail.com
Тема BUG #14116: Character with value 0x0a must be escaped. using COPY FROM
Дата
Msg-id 20160427080251.18208.4233@wrigleys.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #14116: Character with value 0x0a must be escaped. using COPY FROM  (Francisco Olarte <folarte@peoplecall.com>)
Список 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 по дате отправления:

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #14109: pg_rewind fails to update target control file in one scenario
Следующее
От: jsteffee@bepress.com
Дата:
Сообщение: BUG #14117: psql and pg_dump commands should use ENV perl