Now that I fixed the rows that had the inadvertent newlines in one column, I'm trying to read in the fixed table from the .sql file produced by pg_dump. I know there are duplicate rows now that I removed the newlines, and those are easily fixed (although the reported line numbers don't match what I see in emacs). There is, however, one problem that I don't understand so I can't find the row and fix it. Here's what psql reports: \i /<full-path-to-file>/chemistry.sql SET SET SET SET SET SET SET SET SET CREATE TABLE ALTER TABLE psql:/<full-path-to-file>/chemistry.sql:47475: ERROR: invalid input syntax for type real: " " CONTEXT: COPY chemistry, line 47363, column quant: " " Line 47475 is below the last line with content in the file. Line 47363 contains: 96-A000890 SC 1996-04-23 Conductance, Specific 394 uS/cm t \N \N \N (which is wrapped here, but not in the emacs buffer). There are 10 columns, which is how many there should be. When I go to the end of the line there's no space or other extraneous character. The column 'quant' contains the number 394. While that's an integer, the column domain is real and psql doesn't complain about other whole numbers in that column. Please help me understand what the error message and context are telling me because I just don't see it. Rich -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
