Stef <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings