export PAGER=’less -RSX’
Whereas on windows, you can customize psql output like linux, but with the help of windows tool less.exe which is similar to linux. Below, I copied download link of less.exe, download the binaries which are in zip format and unzip to your desired location.
Now, set the windows system variable PAGER and VALUE pointing to the less.exe location. Also, include less.exe location in “Path”. After setting system variable, your psql terminal has all sort of functionality like LESS command in linux. “less.exe -F <filename>”, behaves as “tail -f” in linux. Many more feature in less.exe which I haven’t tried but you can give a try and make your psql output eye-catching :).
PAGER setting screenshot: