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