Miscellaneous Tools

pspg

pspg is a terminal pager built for PostgreSQl to make psql easier to use, especially useful when dealing with tables that have lots of columns. Take a look at this issue for an example before and after.

To install it you can run the following inside the Vagrant box:

# Install pspg itself.
sudo apt install -y pspg

# Set psql to use pspg as the pager.
echo 'export PSQL_PAGER="pspg -X -b"' >> "$HOME/.bashrc"

# Apply the changes in the current session. Exiting and re-entering the
# Vagrant box works too.
source "$HOME/.bashrc"

From there on any time you enter the PostgreSQL database using psql you will have a nicer pager to aid you.