Re: [GENERAL] COPY from and NULL values for double precisions fields

2007-03-04 Thread Andrej Ricnik-Bay
On 3/5/07, Walter Vaughan <[EMAIL PROTECTED]> wrote: For best help it would be good to include your copy statement. As a guess, I'd say you need to include the following in the statement... NULL '' Thanks Walter, I found the cause of my troubles; it wasn't copy, it was the data. I didn't che

Re: [GENERAL] COPY from and NULL values for double precisions fields

2007-03-04 Thread Walter Vaughan
Andrej Ricnik-Bay wrote: I'm currently mucking around w/ importing TAB-delimited files; how can I import empty values into a double precision field? COPY complains about nothing between the TABS, about "\N" and other variations, as being "invalid input syntax for type double precision:" For b