Re: remove embedded carriage returns

From: chwy_nougat(at)yahoo(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: Re: remove embedded carriage returns
Date: 2007-01-10 21:00:52
Message-ID: 1168462851.989004.41090@p59g2000hsd.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


chwy_nou(dot)(dot)(dot)(at)yahoo(dot)com wrote:
> 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...

Is there a different board that I should post this question to?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeanna Geier 2007-01-10 21:16:04 Problems With VIEWS
Previous Message brian 2007-01-10 20:55:31 Re: Trying to load MySQL data