title: postgresql copy few csv columns to specific column on my table
body: <p>i used postgresql copy to store my csv file to my table. But the thing is on my csv table i have 4field</p>
  
  <pre><code>f2 f5 f6 f13
  </code></pre>
  
  <p>and on my postgresql table have 8 table</p>
  
  <pre><code>f1 f2 f3 f4 f5 f6 f7 f8
  </code></pre>
  
  <p>and i want to make f1 the sequence i make, and f3 is current_date and the other is null</p>
  
  <p>this is similiar to <a href="https://stackoverflow.com/questions/12618232/copy-a-few-of-the-columns-of-a-csv-file-into-a-table">my question</a>, but that question is asked on 2013 (maybe now there is other solution?)</p>
  
  <p>The point is i want to insert from specific column from csv to specific column postgresql, if possible i dont want to make temporary table</p>