title: ERROR: invalid input syntax for integer: "1 N N
body: <p>I was trying to import Postgresql .sql backup file into my local PostgreSQL data base. When it reaches copy command I am getting an error because \N is not read as null. import sample copy command</p>
  
  <pre><code>COPY address (id, city, company_name, country, created_date_time, email) FROM stdin;
  </code></pre>
  
  <blockquote>
    <p>1       \N      \N      \N      2018-07-05 16:03:41.717 abc@gmail.com</p>
  </blockquote>
  
  <p>which gets me</p>
  
  <blockquote>
    <p>ERROR:  invalid input syntax for integer: "1       N      N  </p>
  </blockquote>
  
  <p>restore command: </p>
  
  <pre><code>psql -U xxxxx -d xxx -1 -f dump.sql -v ON_ERROR_STOP=1
  </code></pre>