title: Import CSV data with delimiter tabulation in PostgreSQL
body: <p>I have a csv file with data like "44444     521     hello".
  Scapes here are "Tabulations".</p>
  
  <p>I want to import csv data in a table named "TEST1" so i did this : </p>
  
  <pre><code>\copy TEST(attribut1,attribut2,attribut3) FROM '/mnt/c/Users/user1/Desktop/data/test1.csv' WITH DELIMITER E'\t' CSV HEADER;
  </code></pre>
  
  <p>attribut1 = integer. attribut2 = integer. attribut3 = varchar(20).</p>
  
  <p>And it said : </p>
  
  <blockquote>
    <p>ERROR:  invalid input syntax for integer: "44444     521     hello"
    CONTEXT:  COPY test1, line 2, column attribut1: "4444444     521
    hello"</p>
  </blockquote>
  
  <p>Thanks for your time.</p>
  
  <p><strong>EDIT</strong> : </p>
  
  <p>Here is a screenshot of the file in a hex editor : <a href="https://i.stack.imgur.com/YYE6O.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/YYE6O.png" alt="enter image description here"></a></p>