Re: copy data into table error

"Johnson, Shaunn" <SJohnson6(at)bcbsm(dot)com> writes:
> But when I change the table structure from char(2) to char(3)
> the data gets imported. I'm thinking I have some odd dos
> or control character (^M) in the column, but, when I use vi, I
> can't find it and I've stripped out all spaces. What is
> the error talking about? What is in the last column (text file)
> that PostgreSQL is seeing that I (or, vi) can not?

Are you sure the file is not being saved with Windows-style newlines
(^M^J)? COPY only likes Unix-style newlines (^J) --- it will see the
^M as a data character. (This behavior will likely change for 7.4
but that's how current releases behave.)

regards, tom lane