Re: Weird psql problem

From: Martijn van Oosterhout <kleptog(at)svana(dot)org>
To: Jeffrey Melloy <jmelloy(at)visualdistortion(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Weird psql problem
Date: 2003-08-27 12:48:09
Message-ID: 20030827124809.GD17755@svana.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Aug 26, 2003 at 10:06:51AM -0500, Jeffrey Melloy wrote:
> I recently noticed that in my web app, a \n wasn't getting converted to
> a <br />. (The problem turned out to be that for this particular
> record, it was a \r).
>
> When I checked out the record in psql, I got some weird behavior.
>
> What shows up in the web:
> amoth4:it is o.o
> jm:Speaking of being a sounding board, will you test something?
> jm:Ot
> jm:It's pretty quick

On many terminals, \r jumps back to the beginning of the line. Hence in this
example:

> jm:It's pretty quick | 4 | 126 | 's' 'jm' 'ot' 'o.o'
> 'test' 'board' 'quick' 'sound' 'speak' 'amoth4' 'pretti' 'someth'

you're not seeing the starting text because it's overwritten by the later
text.

--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> "All that is needed for the forces of evil to triumph is for enough good
> men to do nothing." - Edmond Burke
> "The penalty good people pay for not being interested in politics is to be
> governed by people worse than themselves." - Plato

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Robby Russell 2003-08-27 12:57:54 Re: SQL Command - To List Tables ?
Previous Message Bruno Wolff III 2003-08-27 12:30:20 Re: update entire table (with PostGreSQL alone)?