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