Inserting TEXT with multiple lines

From: Rick Jones <RJones(at)NAHRO(dot)org>
To: "Pgsql-Novice (E-mail)" <pgsql-novice(at)postgresql(dot)org>
Subject: Inserting TEXT with multiple lines
Date: 2001-01-22 18:35:16
Message-ID: 317B66EE573BD1118CBE00C0F016C5D464DEDC@COMM1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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(at)nahro(dot)org
Toll Free (877) 866-2476 or (202) 289-3500 ext. 248

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2001-01-22 22:00:56 Re: Inserting TEXT with multiple lines
Previous Message Tom Lane 2001-01-22 17:21:20 Re: per backend nofsync