JSON Failed to import

Ariel Abadi aabadi at starconnecting.com
Thu Apr 21 21:26:12 CEST 2016


Hi!

Can someone help me ? Im trying to upload a CSV file with json data, but Im
receiving an error. Does anybody has an idea how to solve this?

Thks in advance

mclient  -s"COPY 1 RECORDS INTO traf.jsontbl FROM STDIN  USING  DELIMITERS
 '|','\n','\"' NULL AS 'null'" - < j.csv

*The data on j.csv is:*
301|"{\"data\":[{\"cdr_dialnumber\":\"6596871820\"}]}"


*TABLE  traf.xx*
sql>\d jsontbl
CREATE TABLE "traf"."jsontbl" (
"a" INTEGER,
"b" JSON
);
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://www.monetdb.org/pipermail/users-list/attachments/20160421/55af975a/attachment.html>


More information about the users-list mailing list