UPDATE table: Syntax to Remove Terminal '\n'

[Rich Shepard <rshepard@xxxxxxxxxxxxxxx>]

  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


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general