Re: need help with copy function

On Thu, Aug 19, 2004 at 16:47:55 +0800,
  Robert Ngo <robertngo@perridot.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
>