将CSV文件导入PostgreSQL [英] Importing CSV file into PostgreSQL

问题描述

使用MySQL管理员GUI工具我已经导出一些从sql转储文件检索到csv文件的数据表。

Using MySQL Administrator GUI tool I have exported some data tables retrieved from an sql dumpfile to csv files.

然后我试图将这些CSV文件导入到PostgreSQL数据库使用postgres COPY命令。我已尝试输入

I then tried to import these CSV files into a PostgreSQL database using the postgres COPY command. I've tried entering

COPY articles FROM '[insert .csv dir here]' DELIMITERS ',' CSV;

以及不带分隔符部分的命令。

and also the same command without the delimiters part.

我得到一个错误：

ERROR: invalid input syntax for integer: "id"
CONTEXT: COPY articles, line 1, column id: "id"

总之，我的问题是和解决这个问题？它可能是与我创建的csv文件的方式有关吗？

In conclusion my question is what are some thoughts and solutions to this problem? Could it possibly be something to do with the way I created the csv files? or have I made a rookie mistake elsewhere?

推荐答案

如果您有标题列，只需将标题限定符添加到复制语句为止
跳过该行的文档
http：/ /www.postgresql.org/docs/8.4/static/sql-copy.html

If you have header columns just add the header qualifier to the copy statement as per documentation to skip that line http://www.postgresql.org/docs/8.4/static/sql-copy.html

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