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