line length line break issue

Поиск
Список
Период
Сортировка
Искать

line length line break issue

От:
David Bear <iddwb@moroni.pp.asu.edu>
Дата:
we had someone make a php app that was a form fill-in type of questionaire.   
They stored all data into postgres as vchar type columns.  Now the problem we 
have is that 
1) rows retrieved from select include cr/lf chars from the form, makeing a row 
multi lines long
2) rows are so long that their not useable and we can find a useable delimeter 

I've tried using 
\pset recordsep "^" 
 (and other chars along with the caret) but it seems the postgress is not 
using that character.  My thinking was to strip all cr/lf, the replace the 
caret with a newline.  Then we could bring the data into something like 
excel.

The problem is the recordsep doesn't seem to work.  Any thoughts?
-- 
David Bear
College of Public Programs/ASU

Re: line length line break issue

От:
Andrew Sullivan <andrew@libertyrms.info>
Дата:
On Tue, Oct 22, 2002 at 06:00:57PM -0700, David Bear wrote:
> \pset recordsep "^" 
>  (and other chars along with the caret) but it seems the postgress is not 
> using that character.  My thinking was to strip all cr/lf, the replace the 
> caret with a newline.  Then we could bring the data into something like 
> excel.

recordsep is for the character _between records_.  But the cr/lf you
have in the data is inside your records.

What you probably want to do is to experiment with the regular
expressions facilities of PostgreSQL, and use the text-manipulation
functions to get rid of the cr/lf.  Or, you could edit the dump file
using, say, sed, and then import the data again.  Obviously, you also
need to fix the PHP.

A


-- 
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
                              M2P 2A8
                                         +1 416 646 3304 x110

FAQ