Postgres Pro
Downloads
Home   >   mailing lists

Re: remove embedded carriage returns - Mailing list pgsql-general

From Jonathan Hedstrom
Subject Re: remove embedded carriage returns
Date
Msg-id 45A55E73.9080006@desc.org
Whole thread Raw
In response to remove embedded carriage returns  (chwy_nougat@yahoo.com)
Responses Re: remove embedded carriage returns  ("Kj" <kurtisj@gmail.com>)
List pgsql-general
Tree view 
chwy_nougat@yahoo.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
Attachment

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Export to shape file
Next
From: Walter Vaughan
Date:
Subject: Re: Trying to load MySQL data