Re: Data In Tables Sometimes Have +

Carlos Mennens <carlos.mennens@gmail.com> writes:
> I've noticed as I interact with my database I use for customers, there
> are from time to time values that have a strange '+' character. For
> example:

> forge=# SELECT cust_id, cust_name, cust_contact, cust_email
> FROM customers
> WHERE cust_name Like 'Truth%';
>   cust_id   |     cust_name      | cust_contact  |     cust_email
> ------------+--------------------+---------------+---------------------
>  1020105577 | Truth Custom Drums | Geoff Barrios | info@truthdrums.com+
>             |                    |               |
> (1 row)

That's a line-break marker.  Looks like you have embedded or trailing
newlines in some of your field values.

            regards, tom lane