Re: COPY from and NULL values for double precisions fields

From: "Andrej Ricnik-Bay" <andrej(dot)groups(at)gmail(dot)com>
To: "Walter Vaughan" <wvaughan(at)steelerubber(dot)com>, PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: COPY from and NULL values for double precisions fields
Date: 2007-03-05 03:09:47
Message-ID: b35603930703041909u48cb76d4y9b4441d6b01c6125@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 3/5/07, Walter Vaughan <wvaughan(at)steelerubber(dot)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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mageshwaran 2007-03-05 03:35:28 Postgres Replication
Previous Message Bill Moran 2007-03-05 02:28:53 Re: real multi-master replication?