By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,553 Members | 851 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,553 IT Pros & Developers. It's quick & easy.

PosgreSQL JSON

P: 2
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
2 Weeks Ago #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.