In zsh, pressing UP searches through the history and brings up all matching commands, even if they are duplicates. That means, sometimes you need to press UP many times to actually find a previous match.
However, it is possible to disable this behaviour and skip duplicate entries from the history. To do that, add one line to your
Ever wished for a feature-rich, intuitive command-line postgresql client? Look no further! Presenting, pgcli — a result of pouring creativity into features rather than the name of the tool.
- Smart autocompletion for almost anything. Even column names in the select query are properly autocompleted from the table you are selecting from;
- Multi-line query editing support;
- SQL Syntax highlighting;
- CLI parameters compatible with psql params. No need to relearn anything;
- Vi mode, allowing to edit multi-line queries using some of the vi bindings. There are also Emacs bindings too;
- Installation as easy as
pip install pgcli (and if that fails, fix is as easy as
xcode-select --install (usually));
Grab your copy today!