Thread: Inserting TEXT with multiple lines

Inserting TEXT with multiple lines

From

Rick Jones

Date:

22 January 2001, 16:32:01

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:

nahro=# COPY jobswanted FROM '/home/httpd/html/documents/jobswanted.txt';
***(Single step mode: Verify
query)*********************************************
COPY jobswanted FROM '/home/httpd/html/documents/jobswanted.txt';
***(press return to proceed or enter x and return to
cancel)********************

": can't parse "ne 1, pg_atoi: error in "112
nahro=#

Rick Jones
Online Information Manager
National Association of Housing and Redevelopment Officials (NAHRO)
http://www.nahro.org
630 Eye St. NW, Washington, DC 20001-3736
rjones@nahro.org
Toll Free (877) 866-2476 or (202) 289-3500 ext. 248

Re: Inserting TEXT with multiple lines

From

Tom Lane

Date:

22 January 2001, 20:01:05

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