psql overwrites command line

From: Malik Rumi <malik(dot)a(dot)rumi(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: psql overwrites command line
Date: 2015-04-11 20:35:10
Message-ID: CAKd6oByHO0Fw20NK-Sjju_BHi5BEMwRV4+hXQwisCNC0MM+SiA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

I am working my way through the tutorial in the official docs. I am on
Ubuntu 14.04 (Unity).

Twice I have had a series of tildes, one per line, show up after a command
is executed, followed by END. The cursor is blinking at END, but there is
no command prompt. I did \q and then the command prompt re-appeared, but
the command before it, and the result, vanished.

Now I am also getting a situation where the cursor does not go to a newline
while writing out commands, and instead starts overwriting the existing
command from the beginning:

--
her.datSELECT weather.city, weather.temp_lo, weather.temp_hi, weather.prcp,
weat
--

Then I am also getting scattered pieces of the commands within the results,
like this:

--
mydb=# SELECT * FROM weather, cities WHERE city = name;
WHERE city =name;
city | temp_lo | temp_hi | prcp | date | location
---------------+---------+---------+------+------------+-----------
San Francisco | 46 | 50 | 0.25 | 1994-11-27 | (-194,53)
San Francisco | 43 | 57 | 0 | 1994-11-29 | (-194,53)
(2 rows)

;
city | temp_lo | temp_hi | prcp | date | location
weather.city;
---------------+---------+---------+------+------------+-----------
San Francisco | 46 | 50 | 0.25 | 1994-11-27 | (-194,53)
San Francisco | 43 | 57 | 0 | 1994-11-29 | (-194,53)
(2 rows)
--

Note the extraneous semi colon above the location in the second table, as
well as the extraneous weather.city; and the duplicated WHERE city =name;
in the first table.

Can someone tell me a) what is going on here and b) how to fix it? Thanks.

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2015-04-11 20:51:20 Re: psql overwrites command line
Previous Message Rafat Qubaj 2015-04-09 05:11:14 PostgreSQL 8.4