Robert Fitzpatrick <robert@webtent.com> writes:
> Does COPY require values for each column even though the database field
> is not set to NOT NULL?
If you want a NULL then you have to write the specified null
representation (which is \N by default, not an empty string).
regards, tom lane