Pgcli is a command line interface for Postgres database that does auto-completion and syntax highlighting. You can install this version by:
$ pip install -U pgcli
Check detailed instructions if you're having difficulty.
This is a minor bug-fix release that fixes the syntax-highlighting of various Postgres specific keywords and adds the ability to surface messages thrown by sql exceptions.
- Add more SQL keywords for auto-complete suggestion.
- Messages raised as part of stored procedures are no longer ignored.
- Use postgres flavored syntax highlighting instead of generic ANSI SQL.