Re: UPDATE table: Syntax to Remove Terminal '\n' [RESOLVED] - Mailing list pgsql-general

On Wed, 27 Aug 2014, Jeff Ross wrote:

> You want the E in front of the entire string, not just before the \n.
> select
> 'Use Discover: ' || E'\t' || 'Yes'  || E'\n'

Jeff,

   That did the trick. Turns out that 202 of 204 rows had the newline! The
syntax that worked:

update benthos set stream = 'StarvationCrk' where stream = E'StarvationCrk\n';

Much appreciated,

Rich