title: Postgresql COPY CSV ERROR: extra data after last expected column
body: <p>I'm trying to import the data from <a href="http://www.unitedstateszipcodes.org/zip-code-database">http://www.unitedstateszipcodes.org/zip-code-database</a>. A subset of the data looks like this:</p>
  
  <pre><code>"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","UNIQUE","Holtsville",,"Irs Service Center","NY","Suffolk County","America/New_York","631","40.81","-73.04","NA","US","0","0"
  </code></pre>
  
  <p>The postgresql command I running is this:</p>
  
  <pre><code>copy development.zip_codes FROM '/tmp/zip_code_database.csv' WITH DELIMITER ',' CSV HEADER;
  </code></pre>
  
  <p>And the result is this:</p>
  
  <pre><code>ERROR: extra data after last expected column
  SQL state: 22P04
  Context: COPY zip_codes, line 2: ""00501","UNIQUE","Holtsville",,"I R S Service Center","NY","Suffolk County","America/New_York","631"..."
  </code></pre>
  
  <p>What am I doing wrong with the import?</p>