Copy from file: ERROR: invalid input syntax for integer: "\N"
Use the NULL parameter. From the documentation:


  NULL
  
  Specifies the string that represents a null value. The default is \N (backslash-N) in text format, and an unquoted empty string in CSV format. 


Example

copy my_table from '/my/csv_file.csv' (format csv, null '\N');