Re: COPY from and NULL values for double precisions fields - Mailing list pgsql-general

From Walter Vaughan
Subject Re: COPY from and NULL values for double precisions fields
Date
Msg-id 45EB804E.4080004@steelerubber.com
Whole thread Raw
In response to COPY from and NULL values for double precisions fields  ("Andrej Ricnik-Bay" <andrej.groups@gmail.com>)
Responses Re: COPY from and NULL values for double precisions fields  ("Andrej Ricnik-Bay" <andrej.groups@gmail.com>)
List pgsql-general
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

pgsql-general by date:

Previous
From: "Andrej Ricnik-Bay"
Date:
Subject: COPY from and NULL values for double precisions fields
Next
From: Bill Moran
Date:
Subject: Re: real multi-master replication?