Re: Data In Tables Sometimes Have +

Carlos Mennens <carlos(dot)mennens(at)gmail(dot)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(at)truthdrums(dot)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