pgcli

Posted on:

ov can be set as a pager for pgcli.

~/.config/pgcli/config

pager = 'ov -C -d "|" --skip-lines 1 -H1'

In pgcli, you can display multiple results. In such cases, it is convenient to use section headers instead of fixed header lines. By setting table_format to psql_unicode, a frame is displayed in Unicode, allowing you to specify the separation of query results. You set the section header by specifying the start of that frame.

pager = 'ov -C -d "│" --section-delimiter "^┌" --section-header-num 3 --column-rainbow --column-mode'
table_format = psql_unicode

pgcli-section pgcli-section