Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-novice by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group