Dumping DB containing json

Поиск
Список
Период
Сортировка
От Michael Kovacs
Тема Dumping DB containing json
Дата
Msg-id CAPp5r6KOObLWP+SvE5T10A5XX19CmkNf3izibM58Dc405rEd1w@mail.gmail.com
обсуждение исходный текст
Ответы Re: Dumping DB containing json
Список pgsql-novice
Дерево обсуждения
Hi there,

I'm currently stuck on a problem with a db dump from pg_dump that contains a database with text columns containing json. I'm wondering if there's something I need to do to properly dump the data that I'm not doing or to restore.

This is how I'm doing each:

pg_dump -U postgres mydb -f myfile.sql

and to restore:

psql -U postgres mydb -f myfile.sql

I get tons of errors about the nulls in the data along with the following syntax errors:

psql:rm_prod-1-19-2012.sql:148863: invalid command \N
psql:rm_prod-1-19-2012.sql:148864: invalid command \N
psql:rm_prod-1-19-2012.sql:148865: invalid command \N
psql:rm_prod-1-19-2012.sql:148866: invalid command \N
psql:rm_prod-1-19-2012.sql:148867: invalid command \N
psql:rm_prod-1-19-2012.sql:148868: invalid command \
psql:rm_prod-1-19-2012.sql:148870: invalid command \N
psql:rm_prod-1-19-2012.sql:148871: invalid command \N
psql:rm_prod-1-19-2012.sql:148877: invalid command \N
psql:rm_prod-1-19-2012.sql:148879: invalid command \N
psql:rm_prod-1-19-2012.sql:148882: ERROR:  syntax error at or near "",""
LINE 1: ","text":"RT @GSElevator: #1: Congress is allowed to trade o...
        ^
psql:rm_prod-1-19-2012.sql:148882: ERROR:  syntax error at or near "a"
LINE 1: a href="
        ^
psql:rm_prod-1-19-2012.sql:148882: ERROR:  syntax error at or near "http"
        ^
psql:rm_prod-1-19-2012.sql:148882: ERROR:  syntax error at or near "rel"
LINE 1: rel="
        ^
psql:rm_prod-1-19-2012.sql:148882: ERROR:  syntax error at or near "nofollow"
LINE 1: nofollow"
        ^
psql:rm_prod-1-19-2012.sql:148882: ERROR:  syntax error at or near "&"
LINE 1: >
        ^
psql:rm_prod-1-19-2012.sql:148882: invalid command \
psql:rm_prod-1-19-2012.sql:148892: invalid command \N


Any guidance on what I'm doing wrong would be appreciated. 

Thanks,
-Michael

В списке pgsql-novice по дате отправления: