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, whole thread or download thread mbox)
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
COPY jobswanted FROM '/home/httpd/html/documents/jobswanted.txt';
***(press return to proceed or enter x and return to

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

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


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-2017 The PostgreSQL Global Development Group