Re: psql overwrites command line

On 11 Apr 2015 10:52 PM, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> Malik Rumi <malik(dot)a(dot)rumi(at)gmail(dot)com> writes:
> > [ assorted misbehavior ]
> > Can someone tell me a) what is going on here and b) how to fix it?
Thanks.
>
> What it looks like is that psql has the wrong idea about what sort of
> terminal you're using (ie, which command language your terminal
> window understands). With no more info than that you're on Ubuntu,
> it's hard to be more specific than that. But try "echo $TERM" at the
> shell command line to see what psql is being told about this, and then
> see if that squares with the documentation about your terminal program.

Also if you have binary data that is output to the terminal as a result of
one of your queries it might have messed up your terminal in which case you
could choose one of the reset options from the menu to see if it helps.