大佬教程收集整理的这篇文章主要介绍了database – Postgresql COPY CSV ERROR:上一个预期列之后的额外数据,大佬教程大佬觉得挺不错的,现在分享给大家,也给大家做个参考。
"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"
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问题?)
以上是大佬教程为你收集整理的database – Postgresql COPY CSV ERROR:上一个预期列之后的额外数据全部内容,希望文章能够帮你解决database – Postgresql COPY CSV ERROR:上一个预期列之后的额外数据所遇到的程序开发问题。
如果觉得大佬教程网站内容还不错,欢迎将大佬教程推荐给程序员好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。