如何从CSV文件复制到PostgreSQL表与CSV文件中的标题? [英] How to copy from CSV file to PostgreSQL table with headers in CSV file?
问题描述
我想将CSV档案复制到Postgres表格。在这个表中有大约100列,所以如果我不需要重写它们。
I want to copy a CSV file to a Postgres table. There are about 100 columns in this table, so I do not want to rewrite them if I don't have to.
我使用 \copy table from'table.csv'delimiter','csv;
命令但没有创建表我获得错误:关系表不存在
。如果我添加一个空表,我得到没有错误,但什么也没有发生。我尝试这个命令两三次,没有输出或消息,但是当我通过PGAdmin检查表时没有更新。
I am using the \copy table from 'table.csv' delimiter ',' csv;
command but without a table created I get ERROR: relation "table" does not exist
. If I add a blank table I get no error, but nothing happens. I tried this command two or three times and there was no output or messages, but the table was not updated when I checked it through PGAdmin.
有没有办法导入包含标题的表格,如我想做的那样?
Is there a way to import a table with headers included like I am trying to do?
推荐答案
这工作。第一行有列名。
This worked. The first row had column names in it.
COPY wheat FROM 'wheat_crop_data.csv' DELIMITER ';' CSV HEADER
这篇关于如何从CSV文件复制到PostgreSQL表与CSV文件中的标题?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!