Jonathan Hedstrom wrote: > chwy_nougat@xxxxxxxxx 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@xxxxxxxx > 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.
