Re: Apparent Problem With NULL in Restoring pg_dump

On 15 Sep 2011, at 19:31, Rich Shepard wrote:

> The .sql file produced by pg_dump is properly terminated with '\.' as the
> last line, yet I continue to encounter this error:
>
> ERROR: invalid input syntax for type real: " "
> CONTEXT: COPY chemistry, line 47363, column quant: " "
>
> when trying to re-create the table.
>
> It appears that this error is generated when a row has a missing value in
> the 'quant' column and the column contains '\N' in the text file. For
> example,
>
> \N GW-22 2005-03-09 Depth to Water \N Feet \N
> \N \N \N
>
> (It is a single line in emacs but wraps in alpine.)

You appear to have two tabs after "Depth to Water", which would be one too many.

Alban Hertroys

--
The scale of a problem often equals the size of an ego.