title: python Postgresql: Ignoring the last column from csv file
body: <p>I have problem with importing a CSV file. I am using postgresql's COPY FROM command to copy a CSV file into a 2-column table. </p>
  
  <p>I have a CSV file in the following format;</p>
  
  <pre><code>"1";"A"
  "2";"B"
  "3";"C";"CAD450"
  "4";"D";"ABX123"
  </code></pre>
  
  <p>I want to import all these lines of the CSV file into the table but I want to skip any extra added columns.</p>
  
  <p>Currently I am skipping any lines that contain extra columns, for example here columns <code>"1";"C";"CAD450"</code> and <code>"1";"D";"ABX123"</code> are skipped  and I am importing only the first two columns. But I want to copy all these four lines into my table. So is there any way where I can ignore the last column and copy all the four lines into my table, like this</p>
  
  <pre><code>"1";"A"
  "1";"B"
  "1";"C"
  "1";"D"
  </code></pre>