| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
| Cc: | Rich Shepard <rshepard(at)appl-ecosys(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Appended '+' in Column Value |
| Date: | 2014-08-22 22:23:31 |
| Message-ID: | 9566.1408746211@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> writes:
> On 08/22/2014 03:03 PM, Rich Shepard wrote:
>> On Sat, 23 Aug 2014, Ian Barwick wrote:
>>> You have a newline character. Try:
>>> select count(*) from benthos where stream = E'StarvationCrk\n';
> Yeah, means either whoever inputted the data kept hitting Enter after
> each string(most of the time) or whatever program input the data added \n.
BTW, see \pset (particularly the linestyle option) in the psql man page
for documentation of this behavior and the options for changing it.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Brodie S | 2014-08-22 22:47:37 | Re: ERROR: Problem running post install step |
| Previous Message | Adrian Klaver | 2014-08-22 22:15:30 | Re: Appended '+' in Column Value |