title: COPY FROM csv file into Postgresql table and skip id first row
body: <p>simple question I think but I can't seem to find the answer through Googling etc.</p>
  
  <p>I am importing csv data into a postgresql table via psql. I can do this fine through the pgAdmin III GUI but am now using Codio Online IDE where it is all done through psql. </p>
  
  <p>How can I import into the Postgresql table and skip the first 'id' auto incrementing column?</p>
  
  <p>In pgAdmin it was as simple as unselecting the id column on the 'columns to import' tab.</p>
  
  <p>So far I have in the SQL Query toolbox</p>
  
  <pre><code>COPY products FROM '/media/username/rails_projects/app/db/import/bdname_products.csv' DELIMITER ',' CSV; 
  </code></pre>
  
  <p>Alternatively, is it possible to get an output on the SQL that PgAdmin III used after you execute an Import using the menu Import command?</p>
  
  <p>Thank you for your consideration.</p>