Home / ubuntu / Questions / 41871
Accepted
tutuca
Asked: 2011-05-11 12:08:30 +0800 CST

Is there syntax highlighting for psql?

  • 772

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

postgresql

2 Answers

  1. Best Answer

    I just found pgcli (https://github.com/dbcli/pgcli) — a postgres client that does auto-completion and syntax highlighting. It looks awesome!

    pgcli in action

    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

    • 12

  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

    • 0