472,143 Members | 1,337 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,143 software developers and data experts.

PosgreSQL JSON

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
Nov 9 '20 #1
0 2989

Post your reply

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

Similar topics

16 posts views Thread by G Matthew J | last post: by
20 posts views Thread by Luke Matuszewski | last post: by
8 posts views Thread by Douglas Crockford | last post: by
2 posts views Thread by Kevin Newman | last post: by
3 posts views Thread by Adam | last post: by
23 posts views Thread by dhtmlkitchen | last post: by
9 posts views Thread by Jon Paal [MSMD] | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.