title: Postgres Copy from file- changing the value of one column
body: <p>I want to copy the content of the file to postgres.
  The file's content is something like this:</p>
  
  <p><code>2014-06-13;Platform;-38193438.530000;EUR</code></p>
  
  <p>Here is my code for copy:</p>
  
  <pre><code>COPY statistics(referencedate, platform, total, currency)
  FROM '/home/output.csv'
  WITH DELIMITER ';';
  </code></pre>
  
  <p>This copy command works, and the lines are inserted. But instead of the word "Platform", I would need to insert the name of the platform for example 'AAA'. My ugly workaround would be running a script and modifying the original file prior to COPY. But I don't really believe that there is not a more elegant solution for this.</p>
  
  <p>I tried the following code but it did not work:</p>
  
  <pre><code> COPY statistics(referencedate, platform, total, currency)
   FROM '/home/output.csv'
   WITH DELIMITER ';' AND platform AS 'AAA';
  </code></pre>