将csv文件导入pgsql [英] Importing csv file into pgsql

问题描述

我尝试将这个CSV档案上传到pgsql
的表格中，但发生这个错误：

I'm trying to upload this CSV file onto my table in pgsql, but I'm getting this error:

ERROR：整数的输入语法无效：mlname，mfname，slname，sfname，address，postalcode，membershiptype，hphone，email

ERROR: invalid input syntax for integer: "mlname,mfname,slname,sfname,address,postalcode,membershiptype,hphone,email"

CONTEXT：COPY members2，line 1，列ID：mlname，mfname，slname，sfname，address，postalcode，membershiptype，hphone，email

CONTEXT: COPY members2, line 1, column id: "mlname,mfname,slname,sfname,address,postalcode,membershiptype,hphone,email"

为什么我得到这个错误，我的表和我的CSV文件有相同的列名称。

I really understand why I'm getting this error, both my table and my CSV file have the same column names.

members2是表的名称，我的所有列都是charvar，所以我不知道如何告诉我关于整数的任何信息。

members2 is the name of the table and all my columns are charvar, so I don't see how it can be telling me anything about integers.

推荐答案

。问题是，你试图输入一个整数字段不是一个整数...

Your problem is not the field names... The problem is that you're trying to input something into an integer field which is not an integer...

到我可以看到..你试图在字段members2 ...

as far as i can see.. you're trying to insert a string into field members2...

这篇关于将csv文件导入pgsql的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！