Home / ubuntu / Questions / 1039090
Accepted
philiporlando
Asked: 2018-05-23 08:11:44 +0800 CST

Set PostgreSQL pager to less?

  • 772

I'm trying to get my psql pager output to look nicer.

I've added the following to my ~/.bashrc

export PAGER='less -S'

And I've added these line to my ~/.psqlrc

\x auto
\pset pager on
\setenv PAGER less

Current output:

Current pager output

Desired output:

Desired pager output

postgresql pager

1 Answers

  1. Best Answer

    \setenv PAGER less in .psqlrc overwrites the environment variable with an undesirable different value (without the -S option).

    Either remove it, or change it to \setenv PAGER 'less -S', or create a new environment variable LESS set to -S

    Note that even when less is not called with the -S / --chop-long-lines option, hitting the right arrow key will scroll horizontally and temporarily display lines without wrapping them.

    • 14