Chuck D. wrote:
Pardon me on this, the cat -A report for the failed line (and subsequent
lines) shows ^M$ within the field, not just $.
I assume that is probably a \r\n and postgres wants \r for field data and \n
to end a line.
I've tried working this over with sed but can't get the syntax right. I also
have iconv installed if that would help any. Are there any good tools that
will tell me what this really is instead of just ^M$ ?
If all you just want to do is strip out the ^M, you can run dos2unix on
it, assuming that you are running a *nix distro.
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
