Stef <svb(at)ucs(dot)co(dot)za> writes:
> I found that it was actually a '\\N' value only that causes
> dumps to dump successfully, but fail on import (When using COPY),
> because both '\N' and '\\N' are seen as null by the COPY statement.
This is demonstrably not so. You might have trouble with data coming
from somewhere else, if the source doesn't understand the quoting rules
for COPY data. But I can dump and restore a table containing '\N' and
variants of that without any trouble.
regards, tom lane