database – Postgresql COPY CSV ERROR：上一个预期列之后的额

发布时间：2020-12-13 18:09:46 所属栏目：百科来源：网络整理

导读：我正在尝试从 http://www.unitedstateszipcodes.org/zip-code-database导入数据.数据的子集如下所示： "zip","type","primary_city","acceptable_cities","unacceptable_cities","state","county","timezone","area_codes","latitude","longitude","world_re

我正在尝试从 http://www.unitedstateszipcodes.org/zip-code-database导入数据.数据的子集如下所示：

"zip","type","primary_city","acceptable_cities","unacceptable_cities","state","county","timezone","area_codes","latitude","longitude","world_reg$
"00501","UNIQUE","Holtsville","I R S Service Center","NY","Suffolk County","America/New_York","631","40.81","-73.04","NA","US","0","384","00544","Irs Service Center","0"

我运行的postgresql命令是这样的：

copy development.zip_codes FROM '/tmp/zip_code_database.csv' WITH DELIMITER ',' CSV HEADER;

结果如下：

ERROR: extra data after last expected column
SQL state: 22P04
Context: COPY zip_codes,line 2: ""00501","631"..."

我输入的错误是什么？

像魅力一样,这里……

DROP TABLE zipcodes CASCADE;
CREATE TABLE zipcodes
        ( id serial NOT NULL PRIMARY KEY,zzip varchar NOT NULL UNIQUE,ztype varchar,primary_city varchar,acceptable_cities varchar,unacceptable_cities varchar,state varchar,county varchar,ztimezone varchar,area_codes varchar,latitude varchar,longitude varchar,world_region varchar,country varchar,decommissioned varchar,estimated_population varchar,notes varchar
        ); 

COPY zipcodes (zzip,ztype,primary_city,acceptable_cities,unacceptable_cities,state,county,ztimezone,area_codes,latitude,longitude,world_region,country,decommissioned,estimated_population,notes )
FROM '/tmp/zip_code_database.csv'
        WITH CSV HEADER delimiter ','
        ;

结果：

DROP TABLE
CREATE TABLE
COPY 42522

(也许OP有CR / CRLF问题？)

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!