Postgres Pro
Downloads
Home   >   mailing lists

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

From Rich Shepard
Subject UPDATE table: Syntax to Remove Terminal '\n'
Date
Msg-id alpine.LNX.2.11.1408271523400.11534@localhost
Whole thread Raw
Responses Re: UPDATE table: Syntax to Remove Terminal '\n'
List pgsql-general
Tree view 
   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

pgsql-general by date:

Previous
From: Jim Garrison
Date:
Subject: Atomicity of INSERT INTO ... SELECT ... WHERE NOT EXISTS ...
Next
From: Ian Barwick
Date:
Subject: Re: UPDATE table: Syntax to Remove Terminal '\n'