On Thu, Aug 19, 2004 at 16:47:55 +0800,
Robert Ngo <robertngo(at)perridot(dot)com> wrote:
> copy swpparm from stdin using delimiters ';';
>
> exampaper;02;1;Bahasa Melayu;M;A;2002-11-27;system;;
>
> \.
>
> why does the above command return a error message
It looks like the column that is associated with the empty field has a
type of date. The empty string is not a valid date. If you want a NULL
date then you need to use \N instead of an empty string.
>
>
> ERROR: copy: line 1, Bad date external representation ''
> PQendcopy: resetting connection
>