Adrian Klaver <adrian.klaver@aklaver.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