What is pgcli? http://pgcli.com/ Pgcli is a command line interface for Postgres with auto-completion and syntax highlighting.
Python
python --version
Python 2.7.3
Install pip --user
wget 'https://bootstrap.pypa.io/get-pip.py'
python get-pip.py --user
Setup
export PATH="$HOME/.local/bin:$PATH"
Install pgcli --user
pip install --user pgcli
Run
pgcli --help
Usage: pgcli [OPTIONS] [DATABASE] [USERNAME]
Options:
  -h, --host TEXT     Host address of the postgres database.
  -p, --port INTEGER  Port number at which the postgres instance is listening.
  -U, --user TEXT     User name to connect to the postgres database.
  -W, --password      Force password prompt.
  -w, --no-password   Never prompt for password.
  -d, --dbname TEXT   database name to connect to.
  --help              Show this message and exit.
Update
pip install --user --upgrade pgcli