Copy json from couchbase to postgres

Started by Rushikesh sochaover 5 years ago2 messagesgeneral
Jump to latest
#1Rushikesh socha
rushikesh.s@gmail.com

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.

#2David G. Johnston
david.g.johnston@gmail.com
In reply to: Rushikesh socha (#1)
Re: Copy json from couchbase to postgres

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.