title: Copy a csv column into postgresql with autoincrement
body: <p>I have a csv file with 1.2 million entrys which are representing analog values e.g. current values. When I save a data record I want to insert this values in one go.</p>
  
  <p>When my software has the next run, it needs to know what was the last primary key id. I thought it would be possible that the primary key stuff is handled implicite so that the next run get's it's correct primary key automatically. </p>
  
  <p>In my PostgreSQL database I have the following table</p>
  
  <pre><code>CREATE TABLE tbl_test
  ( id INTEGER primary key,
    value INTEGER
  );
  </code></pre>
  
  <p>Additionally I have a csv coded file with only one column. The Content is as the following:</p>
  
  <pre><code> value 
  ------
    89     
    12    
    234  
  </code></pre>
  
  <p>Then I used the following command to insert my values.</p>
  
  <pre><code>Using writer = conn.BeginTextImport("COPY tbl_test (value) FROM
  'C://temp//analog.csv'")
  </code></pre>
  
  <p>I expected, that the result would be like in the following table, but It wasn't possible to insert the datas like I exptected.</p>
  
  <p>Is it possible to add the content of the csv file with help of the <code>COPY</code> command so that the id column is incremented automatically and the result would be as the following?</p>
  
  <pre><code> id  | value 
  -----+-------
     1 |  89
     2 |  12
     3 |  234
  </code></pre>