What does HackerNews think of pspg?
Unix pager (with very rich functionality) designed for work with tables. Designed for PostgreSQL, but MySQL is supported too. Works well with pgcli too. Can be used as CSV or TSV viewer too. It supports searching, selecting rows, columns, or block and export selected area to clipboard.
Language:
C
> I am regularly surprised how bad the tooling is for SQL/databases.
This. I'd really like to have a working SQL pretty printer/formatter. Psql is great, but lacks autocompletion in several places.
That said, a big shoutout to pspg (https://github.com/okbob/pspg) - an excellent pager for psql (also for general csvs).
pspg ( https://github.com/okbob/pspg ) is wonderful for tabular data.
Link to github: https://github.com/okbob/pspg
pgcli is nice
and it works great with pspg pager [https://github.com/okbob/pspg]
''\pager /usr/local/bin/pspg''
And to complement that, I recommend Postgres Pager (https://github.com/okbob/pspg)