pgcli is a drastically improved version of the standard PostgreSQL command prompt that is included by default in the PostgreSQL stack on Next Tech.
Here's what pgcli looks like in action:
To get started, simply follow the getting started guide on the pgcli website. Some of the things to consider are:
What database to connect mycli to.
Whether or not to make pgcli a terminal start command.
Whether or not to load a starting database.