Postgres Pro
Downloads
Home   >   mailing lists

Thread: Copy json from couchbase to postgres

Copy json from couchbase to postgres

From
Rushikesh socha
Date:
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.

Re: Copy json from couchbase to postgres

From
"David G. Johnston"
Date:
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.