Thread: COPY from and NULL values for double precisions fields

Hi Guys,

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

What *is* valid syntax for this?  Can't find it for the life of me.


Cheers,
Andrej

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

--
Walter

On 3/5/07, Walter Vaughan <wvaughan@steelerubber.com> 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 check the structure, and copy fell over
the stupid line-feeds (^M) in the file.


Cheers,
Andrej