示例CSV行:
"2012","Test User","ABC","First","71.0","","","0","0","3","3","0","0","","0","","","","","0.1","","4.0","0.1","4.2","80.8","847"
"First"之后的所有值都是数字列.很多空值都是这样引用的,对吧.
try 复制:
copy mytable from 'myfile.csv' with csv header quote '"';
不:ERROR: invalid input syntax for type numeric: ""
嗯,是的.这是一个空值.try 2复制:
copy mytable from 'myfile.csv' with csv header quote '"' null '""';
不:ERROR: CSV quote character must not appear in the NULL specification
一个男人该怎么办?在运行COPY
之前删除文件中的所有双引号?我能做到,但我想这是一个非常普遍的问题,有一个合适的解决方案.