Below are screenshots and configs for yet another color prompting of psql. The goal was to get the color prompting scheme that works well on both light and dark background terminals.

Here is an example of .bashrc file:

#!/bin/bash

export YELLOW=`echo -e '\033[1;33m'`
export LIGHT_CYAN …