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
<andrew@libertyrms.info> M2P 2A8
+1 416 646 3304 x110