Re: COPY from and NULL values for double precisions fields

From: Walter Vaughan <wvaughan(at)steelerubber(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: COPY from and NULL values for double precisions fields
Date: 2007-03-05 02:28:30
Message-ID: 45EB804E.4080004@steelerubber.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2007-03-05 02:28:53 Re: real multi-master replication?
Previous Message Andrej Ricnik-Bay 2007-03-05 02:08:42 COPY from and NULL values for double precisions fields