APseudoUtopia <apseudoutopia@gmail.com> writes:
> The file does contain quite a bit of \r\n's in them for newlines
> inside VARCHAR and TEXT columns, but I thought they would be converted
> into actual newlines as I import it, not the actual character strings
> "\n" and "\r".
If they're inside quoted literals or COPY data, yes; but it looks like
you have one instance that isn't.
regards, tom lane