title: Missing data for column while trying to copy a csv file in a postgresql database
body: <p>I have an issue trying to copy a CSV file in a table.
  Here is my SQL statement:</p>
  
  <pre><code>DROP TABLE IF EXISTS nom_graph; 
  
  CREATE TABLE nom_graph 
  (
      DATE            VARCHAR(50),
      EDP_REC     FLOAT,
      EDP_EC      FLOAT,
      NB_KO       FLOAT
  );
  \copy nom_graph FROM '/home/giutools/EDP/out/SYNTHESE_RESYNC.csv' (DELIMITER('|')) 
  ;
  </code></pre>
  
  <p>and this is the error I get: </p>
  
  <pre><code>psql:nom_graph.sql:179: ERROR:  missing data for column "edp_rec"
  CONTEXT:  COPY nom_graph, line 1: "DATE;EDP_REC;EDP_EC;NB_KO"
  </code></pre>
  
  <p>The CSV file is composed by a : date ; and all the other values are FLOAT.</p>
  
  <p>I really can't understand what's the issue, been trying to solve it for two days now.</p>