469,908 Members | 2,213 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,908 developers. It's quick & easy.

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 2840

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
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.