Re: Copy json from couchbase to postgres

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: Copy json from couchbase to postgres
Дата
Msg-id CAKFQuwajaQaDFz-A=emSetoCS_NSEXX+y4O1wvz05nZVkTsfuw@mail.gmail.com
обсуждение исходный текст
Ответ на Copy json from couchbase to postgres  (Rushikesh socha <rushikesh.s@gmail.com>)
Список pgsql-general
On Mon, Oct 26, 2020 at 1:10 PM Rushikesh socha <rushikesh.s@gmail.com> wrote:
Any suggestions on copying .json which is exported from couchbase using cbexport json. I used copy command but most of them are throwing error.

pgdocstore=# copy schaname.tablename from 'path/filename.json';
ERROR:  invalid input syntax for type json
DETAIL:  Token "H" is invalid.

I'd suggest making a self-contained posting including the data you are trying to import and gloss over how it is being generated.  You've gotten enough correct to get a json input syntax error so its the actual data that seems to matter.

David J.

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

Предыдущее
От: Rushikesh socha
Дата:
Сообщение: Copy json from couchbase to postgres
Следующее
От: Hu Bert
Дата:
Сообщение: Re: postgis update wants to install postgresql-13