title: postgres copy command - fields enclosed with double quotes with comma and separated by comma in csv file
body: <p>i am facing data import issue postgres table. i have data in csv file like.</p>
  
  <blockquote>
    <p>"this", "postgres,sql", "linux","infile","that", "post,sql", "lnux","file"</p>
  </blockquote>
  
  <p>i tried to import data using below command but it is giving error</p>
  
  <blockquote>
    <p>\copy test_table FROM '/home/postgres/testdata/testfile.csv' WITH
       DELIMITER ',' CSV HEADER;</p>
    
    <p>ERROR:  extra data after last expected column</p>
  </blockquote>
  
  <p>so how to eliminate extra comma in double quotes.</p>