Re: need help with copy function

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