Re: No date = bad date?

on 6/26/03 4:26 PM, Josh Berkus at josh(at)agliodbs(dot)com wrote:

>> Does anyone know of some reason why importing a text file that contains no
>> data for one date field would cause psql to tell me:
>>
>> ERROR: copy: line 1, Bad date external representation ''
>> lost synchronization with server, resetting connection
>
> Yes. For the "blank" date, you need to have an \N marker to indicate a NULL.
> Or you need to change your copy parameters to indicate that a zero length
> string is a NULL; check the COPY docs for details.

Thanks - I added "with null as ''" and it worked fine.

Lynna
--
Resource Centre Database Coordinator
Gallery 44
www.gallery44.org