Re: Inserting TEXT with multiple lines

Rick Jones  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