Is there syntax highlighting for psql?

Question

Is there some setting or package that I could use to give syntax highlighting to psql (the PostgreSQL shell)?

Answer 1

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:pa$$w0rd@example.com:5432/app_db

Source: https://github.com/dbcli/pgcli

Answer 2

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