Re: COPY error with null date

[Rajeev rastogi <rajeev.rastogi@xxxxxxxxxx>]

On 21^st March 2014, Ashmita Jain Wrote:

 

>It is taking date as an empty string.

>Try defining the empty field as ‘\N’ in your source file.

 

‘\N’ in copy source file always results into an empty string (unless something written in new line), which is correct only.

So COPY from such source file will always fail except for the case if the column data-type is string.

 

In your case COPY is failing or it is able to insert empty string?

 

 

Thanks and Regards,

Kumar Rajeev Rastogi