Is there some setting or package that I could use to give syntax highlighting to psql
(the PostgreSQL shell)?
2 Answers
I just found pgcli (https://github.com/dbcli/pgcli) — a postgres client that does auto-completion and syntax highlighting. It looks awesome!
Quick Start
If you already know how to install python packages, then you can simply do:
$ pip install pgcli
or
$ brew install pgcli # Only on OS X
If you don't know how to install python packages, please check the detailed instructions.
Usage
$ pgcli [database_name]
or
$ pgcli postgresql://[user[:password]@][netloc][:port][/dbname]
Examples:
$ pgcli local_database
$ pgcli postgres://amjith:[email protected]:5432/app_db
Source: https://github.com/dbcli/pgcli
-
1While this link may answer the question, it is better to include the essential parts of the answer here and provide the link for reference. Link-only answers can become invalid if the linked page changes.– Pilot6Oct 21, 2015 at 13:59
-
@Pilot6 Thanks for pointing it out, added image and more specific info. Oct 23, 2015 at 6:09
I realize this is an old question and @honza-kasik 's a great reply. However, to further add to it, it should be pointed out that Debian-based Linux users should install via APT:
sudo apt install pgcli
Doing this saves a lot of headaches you'd have installing via pip
psql
results or help files, e.g. for\h select