纯工作记录:
按字段顺序,修改excel文档,然后将excel文件转成csv格式
copy funnel_temp from 'c:\\export.csv' with delimiter ',';
结果操蛋的发生错误
错误: 无效的 "UTF8" 编码字节顺序: 0xc6e6
提示: This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".
背景: COPY funnel_temp, 行 1
********** 错误 **********
SQL 状态: 22021
指导建议:This error can also happen if the byte sequence does not match the encoding expected by the server, which is controlled by "client_encoding".
神马问题?
通过UE修改csv文件编码为UTF-8,再次运行:
********** 错误 **********
SQL 状态: 22P04
错误的 COPY 格式(BAD COPY FILE FORMAT)
无果.....
下载了一个 Navicat for PostgreSQL,直接以excel格式导入,指定数据列与字段对应关系,导入,成功