title: PostgreSQL copy command generate primary key id
body: <p>I have a CSV file with two columns: city and zipcode. I want to be able to copy this file into a PostgreSQL table using the <code>copy</code> command and at the same time auto generate the <code>id</code> value. </p>
  
  <p>The table has the following columns: <code>id</code>, <code>city</code>, and <code>zipcode</code>.</p>
  
  <p>My CSV file has only: <code>city</code> and <code>zipcode</code>.</p>