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 = 'Sta
On 14/08/28 8:04, Ian Barwick wrote:
> On 14/08/28 7:31, Rich Shepard wrote:
>> 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
On 14/08/28 7:31, Rich Shepard wrote:
> 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.
>
>
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
