title: Data type when reading from a TSV-file (postgresql)
body: <p>Im reading data from a tsv-file to a postgresql table. The problem I have is that in one column (death year) it is either a year or \N if the actor is not dead yet. If i try to use INTEGER as data type I get an error because of the \N. Do anyone know how to solve this?</p>
  <p>This is my table:</p>
  <pre><code>CREATE TABLE name_mock(nconst VARCHAR, primaryName VARCHAR, birthYear INTEGER, deathYear INTEGER, primaryProfession VARCHAR, knownForTitles VARCHAR);
  
  </code></pre>
  <p>Then I import the data from the csv-file:</p>
  <pre><code>COPY name_mock FROM '/home/pathtofile/name.basics.tsv' DELIMITER E'\t' CSV HEADER;
  
  </code></pre>
  <p>And I get the following error:</p>
  <pre><code>ERROR:  invalid input syntax for type integer: &quot;\N&quot;
  CONTEXT:  COPY name_mock, line 4, column deathyear: &quot;\N&quot;
  
  </code></pre>
  <p>Thank you.</p>