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.
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 |