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