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