Re: copy in date string "00-00-00 00:00:00"

On Mar 14, 2012, at 6:32 PM, Andy Colson wrote:

> On 03/14/2012 08:16 PM, Scott Marlowe wrote:
>>
>>
>> Can you run it through sed and replace the "0000-00-00 00:00:00" to
>> NULL (no quotes) ? That should work.
>>
>
> I think COPY (depending on arguments) uses \N by default.
>
> Another option is to pull it into a temp table and make fix it up from there.
>
> -Andy

Thanks to all who responded. I appreciate it very much.

Yes, that is a good idea. I wasn't sure how to use the NULL clause of the copy command, but I did wonder about other null values in the data set. There are many as this database grew up over 15+ years of use and many renditions of the client application.

I am not familiar with sed, except for some trivial bits I nicked off the web. Enough to know it works, and to be dangerous. Nonetheless, using SED may be the way to go as there are two tables that contain a bit over 3,000,000 rows each.

- Mark