Hi, I would like to know how can i transfer .json file generated from couchbase database to postgresql
I tried copy command but looks like some of the characters from couchbase json is not recognized by postgres
copy schemaname.tabl ename from 'filename.json'
ERROR: invalid input syntax for type json
DETAIL: Token "H" is invalid.
CONTEXT: JSON data, line 1: ...Description" :[{"description": "Adesso® xxxx xx"H...
COPY autoaddcoupon, line 1, column doc: "{"autoxxxDocKe y":"xxxxxxx/xx/xxxxxxx/xxxxxxxx","xxxx xxxxxx":[{"xxxxxxxType": "C","..."
I have replaced real data with x
I tried copy command but looks like some of the characters from couchbase json is not recognized by postgres
copy schemaname.tabl ename from 'filename.json'
ERROR: invalid input syntax for type json
DETAIL: Token "H" is invalid.
CONTEXT: JSON data, line 1: ...Description" :[{"description": "Adesso® xxxx xx"H...
COPY autoaddcoupon, line 1, column doc: "{"autoxxxDocKe y":"xxxxxxx/xx/xxxxxxx/xxxxxxxx","xxxx xxxxxx":[{"xxxxxxxType": "C","..."
I have replaced real data with x