On Thu, 15 Sep 2011, Andy Colson wrote:

To restore, you are using:  psql dbname < filename correct?

Andy,

  Same error.

  BTW, what prompted this was my discovery that about 1400 rows with site_id
= GW-22 had a newline appended to that string. Using emac's
search-and-replace I took those off and new that I would probably have
duplicate records when trying to replace the table. But, I did not expect
these errors of extra characters after the last datum or something about
blanks in real columns.

  If there's a better way for me to drop the \n versions and elimiate one of
the resulting duplicates, please teach me how and I'll go that route.

Thanks,

Rich

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to