尝试将csv文件导入postgresql时,“最后一个预期列之后的额外数据

我的CSV内容是

agency_id,agency_name,agency_url,agency_timezone,agency_lang,agency_phone
100,RATP (100),http://www.ratp.fr/,CET,

我的postgresql命令是

COPY agency (agency_name,agency_timezone) FROM 'myFile.txt' CSV HEADER DELIMITER ',';

这是我的桌子

CREATE TABLE agency (
    agency_id character varying,agency_name character varying NOT NULL,agency_url character varying NOT NULL,agency_timezone character varying NOT NULL,agency_lang character varying,agency_phone character varying,agency_fare_url character varying
);

     Column      |       Type        | Modifiers 
-----------------+-------------------+-----------
 agency_id       | character varying | 
 agency_name     | character varying | not null
 agency_url      | character varying | not null
 agency_timezone | character varying | not null
 agency_lang     | character varying | 
 agency_phone    | character varying | 
 agency_fare_url | character varying |