Re: request for help with COPY syntax

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.