Re: BUG #1341: problem when showing resulted in the screen

"PostgreSQL Bugs List" <pgsql-bugs@postgresql.org> writes:
>  select * from teleoperador;
>  id |  login   |           ip           | tipo
> ----+----------+------------------------+------
>   0 | pablo    | 10.0.0.106             | C
>   1 | builder  | 10.0.0.107
> 10.0.0.107 | C
>   2 | reinaldo | 10.0.0.105             | C
> (3 rows)

Looks to me like you managed to store a carriage return or newline
character (\r or \n) in the ip column.

Is there a reason for using varchar rather than the inet datatype
for that column?  inet would give you some error checking, which
you evidently need.

			regards, tom lane