title: unable to load CSV file in Postgresql
body: <p>I am new to PostgresSQL and i am trying to load a data of the following format:</p>
  
  <pre>
  1,57000000000A,A,EN,0:01,male,hahaha,"Address is address",1234567,Not Applicable,,
  walk in and 
  scream,papa,00:20:54,02:17:41,ABC,00:20:54,02:17:41,musical,farm,,cody,9,bad 
  boy,,,,,X,,rest,,,musical is muscal,John Kotters ,,,2011-01-01
  </pre>
  
  <p>There are more than 10k records and some columns may have NULL data. When i try to do this:</p>
  
  <pre><code>COPY ane FROM 'C:/Program Files (x86)/PostgreSQL/8.4/csv-data/my-data.csv' WITH
  DELIMITER ',';
  </code></pre>
  
  <p>I am getting the following error:ERROR: extra data after last expected column
  SQL state: 22P04</p>
  
  <p>I have checked the columns and they are ok. This means that no columns are left out.</p>
  
  <p>Hope someone can help. Advance thanks.</p>