My table column defined intcol integer; no NOT NULL constraint. In the load file most values are integers, but a few are null values labeled with the '\N' default as suggested by the copy manual. Can the copy command convert '\N' to null values in the table? I also tried with null 'NA'. Got similar error message.
ERROR: invalid input syntax for integer: "\N"
CONTEXT: COPY table_name, line 111, column position3: "\N"
Any trick?