Thread: 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
>

--- 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
>
>
> ERROR:  copy: line 1, Bad date external
> representation ''
> PQendcopy: resetting connection
>
An empty string is not a valid date.
I am guessing that you just wanted the absent value(s)
to be inserted as nulls.  If so, just add "with null
as ''" (that's two single quotes) to your "copy"
statement.
>




_______________________________
Do you Yahoo!?
Win 1 of 4,000 free domain names from Yahoo! Enter now.
http://promotions.yahoo.com/goldrush