Re: Copy json from couchbase to postgres

2020-10-26 Thread David G. Johnston
On Mon, Oct 26, 2020 at 1:10 PM Rushikesh socha 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

Copy json from couchbase to postgres

2020-10-26 Thread Rushikesh socha
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.