Inserting TEXT with multiple lines
От | Rick Jones |
---|---|
Тема | Inserting TEXT with multiple lines |
Дата | |
Msg-id | 317B66EE573BD1118CBE00C0F016C5D464DEDC@COMM1 обсуждение исходный текст |
Ответы |
Re: Inserting TEXT with multiple lines
|
Список | 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@nahro.org Toll Free (877) 866-2476 or (202) 289-3500 ext. 248
В списке pgsql-novice по дате отправления: