title: Handling/editing special characters in a huge file(>2gb)
body: <p>I used java to write into and create a csv file. Since certain fields had ',' in them as part of values I enclosed each column with ' "" ' ((like "allen,jade","123","12 street" )). So the values in my csv file looks like: </p>
  
  <p>"col a value", "col b value" ....</p>
  
  <p>Now when I was trying to upload this file into a postgres (9.1) database using
   COPY tablea  from 'filename.csv' DELIMITER ',' CSV;
   I got an error saying:  extra data after last expected column.</p>
  
  <p>I inspected the record for which the error was displayed and it has a column which has ' " ' as a part of its value.</p>
  
  <p>Precisely this is how it is:</p>
  
  <p>"Halswell Congregation of Jehovah"s Witnesses Christchurch","Christchurch","Halswell Congregation of Jehovah"s Witnesses"</p>
  
  <p>I am guessing it's because of the ' " ' inside the value in the first column that I'm getting this error.</p>
  
  <p>Please correct me if I'm wrong and it would be awesome if you could help me get around this.</p>