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. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
