Re: Apparent Problem With NULL in Restoring pg_dump

On Thu, 15 Sep 2011, Alban Hertroys wrote:

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

Alban,

I thought that I had caught all the double tabs. Thanks for seeing this
one.

Now I'm back to the tabs-in-real-columns issue:

ERROR: invalid input syntax for type real: " "
CONTEXT: COPY chemistry, line 47364, column quant: " "

and here's the referenced line:

\N GW-22 2004-12-17 Calcium 9.69999981 mg/L
\N \N \N \N

Removing the extra tab between 'Calcium' and 9.69999981 produces:

ERROR: invalid input syntax for type numeric: "N N"
CONTEXT: COPY chemistry, line 47364, column northing: "N N"

There must be a better way to clean this table, but I don't know what it
is.

Thanks again,

Rich