remove embedded carriage returns

From: chwy_nougat(at)yahoo(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: remove embedded carriage returns
Date: 2007-01-10 01:06:34
Message-ID: 1168391194.088966.180240@i56g2000hsf.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Outputting a SELECT statement's results to ascii file showed me a table
with a bunch of embedded carriage return characters in the values. I
want to remove the embedded returns, so I read the documentation and
tried a few variations on "SELECT replace(columname, 'chr(13)','') from
tablename" with no luck. Could someone help me rid this table of its
embedded returns?

Thanks in advance...

Responses

Browse pgsql-general by date

  From Date Subject
Next Message garrettmoore@gmail.com 2007-01-10 01:54:03 Trying to load MySQL data
Previous Message Jonathan Hedstrom 2007-01-10 00:05:26 Re: ERROR: invalid memory alloc request size, and others