Postgres Pro
Downloads
Home   >   mailing lists

Re: COPY command with blank incoming values - Mailing list pgsql-general

From Tom Lane
Subject Re: COPY command with blank incoming values
Date
Msg-id 9573.1088743228@sss.pgh.pa.us
Whole thread Raw
In response to COPY command with blank incoming values  (Robert Fitzpatrick <robert@webtent.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: postgresql +AMD64 +big address spaces - does it work?
Next
From: mike g
Date:
Subject: Re: Mysterious performance of query because of plsql