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.tablename 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: "{"autoxxxDocKey":"xxxxxxx/xx/xxxxxxx/xxxxxxxx","xxxxxxxxxx":[{"xxxxxxxType":"C","..."
I have replaced real data with x