Rick Jones <RJones@NAHRO.org> writes:
> In my table there is a "synopsis" field that I want to change so that it
> displays with line breaks (ColdFusion client). Is there an easy way to do
> this? I've tried INSERT. I've used COPY ... FROM with the table and then
> made the modification (using \n for the carriage returns) then tried COPY
> ... TO. When I do that I get the following error:
"\n" should work to represent a newline in COPY data.
> ": can't parse "ne 1, pg_atoi: error in "112
Looks to me like your editor changed all the line endings to \r\n.
Try using a less Windows-ish editor.
regards, tom lane