双引号(如果standard_conforming_strings
已启用,请参阅docs)
COPY my_table FROM 'c:\downloads\file.csv' DELIMITERS ',' CSV QUOTE '''';
COPY my_table FROM 'c:\downloads\file.csv' DELIMITERS ',' CSV QUOTE E'\'';
从具有单引号数据的csv文件中加载postgreSQL数据的正确COPY命令?
双引号(如果standard_conforming_strings
已启用,请参阅docs)
COPY my_table FROM 'c:\downloads\file.csv' DELIMITERS ',' CSV QUOTE '''';
COPY my_table FROM 'c:\downloads\file.csv' DELIMITERS ',' CSV QUOTE E'\'';