postgreSQL导入excel文件

纯工作记录：

按字段顺序，修改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格式导入，指定数据列与字段对应关系，导入，成功