Re: psql: recall previous command?

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: psql: recall previous command?
Дата
Msg-id 200502240512.j1O5CbV24281@candle.pha.pa.us
обсуждение исходный текст
Ответ на psql: recall previous command?  (Neil Conway <neilc@samurai.com>)
Ответы Re: psql: recall previous command?  (Neil Conway <neilc@samurai.com>)
Список pgsql-hackers
Is there a TODO here?

---------------------------------------------------------------------------

Neil Conway wrote:
> Is there a way to recall the previous command in psql? Obviously, "up 
> arrow" or Ctrl-P using readline and the default readline bindings is 
> close, but it recalls the previous _line_ of input. That is not at all 
> the same thing in the case of a multiple line command, for example.
> 
> If there is no way at present, I think there should be. Using "up arrow"
> is quite annoying when dealing with multiple line SQL statements.
> 
> Two issues:
> 
> - how to handle slash commands? Slash commands and SQL statements can be 
> intermixed:
> 
> neilc=# select 1 \timing
> Timing is off.
> neilc-# ;
>   ?column?
> ----------
>          1
> (1 row)
> 
> So I'm not quite sure what the right behavior here is. We could always 
> just ignore slash commands (the command would "recall the previous SQL 
> statement") -- since few slash commands are multi-line, I don't think 
> that would be too bad.
> 
> - when a multiple-line command is recalled, how should it be presented 
> in the psql input buffer? Perhaps we could strip newlines from recalled 
> command text, so that the recalled command would fit on a single line. 
> That would mean the recalled command would look somewhat different than 
> how the user typed it, although of course the semantics of the query 
> should be the same. Any better ideas?
> 
> -Neil
> 
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 8: explain analyze is your friend
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Christopher Browne
Дата:
Сообщение: Finding if old transactions are running...
Следующее
От: Christopher Kings-Lynne
Дата:
Сообщение: Re: Finding if old transactions are running...