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
);