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.