Re: remove embedded carriage returns

Jonathan Hedstrom wrote:
> chwy_nougat(at)yahoo(dot)com wrote:
> > "SELECT replace(columname, 'chr(13)','') from tablename"
>
> Try using chr(13) without the single quotes:
>
> SELECT replace(columname, chr(13),'') from tablename
>
> or you could use '\r' to get the character:
>
> SELECT replace(columname, E'\r','') from tablename
>
>
> -Jonathan
>
> begin:vcard
> fn:Jonathan Hedstrom
> n:Hedstrom;Jonathan
> org:Downtown Emergency Service Center;Information Services
> email;internet:jhedstrom(at)desc(dot)org
> title:Data Systems Administrator
> tel;work:(206) 464-1570 ext. 3014
> version:2.1
> end:vcard
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster

Thanks so much! I am a psql noob and really appreciate your response
and help.