Re: Identifying Reason for Column Name Returned by SELECT

On Wed, Sep 14, 2011 at 12:04 PM, Rich Shepard <rshepard@appl-ecosys.com> wrote:
> On Wed, 14 Sep 2011, Steve Crawford wrote:
>
>> I suspect you have a multi-line entry and the '+' is just indicating that
>> the field continues.
>
> Steve, et al.:
>
>  It's not multi-line, but malformed.

It *is* mult-line.  psql uses a '+ to show line breaks:

postgres=# select E'a\nb';
 ?column?
----------
 a       +
 b
(1 row)

To fix your data, i'd consider using the replace() function to knock
out newlines:
postgres=# select replace(E'a\nb', E'\n', '');
 replace
---------
 ab
(1 row)

Also consider adjusting the app and/or the database to block them in the future.

merlin