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

);