title: POSTGRES - COPY from file with seting one value which is not in FILE
body: <p>I COPY data from my .csv to my postgres table. My command looks like:</p>
  
  <pre><code> COPY w_spare_part_cze (country, manufacturer, model, submodel, guid, model_options, oen, price, description) FROM '/tmp/SpareParts.csv' WITH CSV HEADER DELIMITER ',' QUOTE '"';
  </code></pre>
  
  <p>This looks cool, however in my database I have column <code>country</code> but in my <code>.csv</code> I dont have this column at all ( just have manufacturer, model, submodel, guid, model_options,etc...)</p>
  
  <p>As soon as all the values from this IMPORT is going to have same value for country. Is there a way how to SET IT without locally upload it to another table, add new column with default value, dump and upload again to real table.</p>
  
  <p>Thanks for any advise</p>