UPDATE table: Syntax to Remove Terminal '\n' - Mailing list pgsql-general

   I have some rows in a table where a column attribute has a newline (\n)
appended to the string. How do I represent that newline character in a SQL
statement using psql?

   I've tried adding E'\n' to the end of the string but that doesn't work.

   Here's what I see when I select distinct for that column:

StarvationCrk+


   That's a blank line below the name.

TIA,

Rich