staffs=# copy department from '/home/omm/department.csv';
ERROR: invalid input syntax for integer: "1,销售部,负责公司产品销售工作"
CONTEXT: COPY department, line 1, column d_id: "1,销售部,负责公司产品销售工作"
csv文件内容:
报错信息:
表结构:
...全文
73回复打赏收藏
openGauss数据库导入csv数据:invalid input syntax for integer
用copy导入csv数据到数据库: staffs=# copy department from '/home/omm/department.csv'; ERROR: invalid input syntax for integer: "1,销售部,负