Rad. Last night I realized I could use @VisiData
as the pager for psql. It works so well!
PSQL_PAGER="vd -f csv" psql --csv --pset pager=always
asciinema.org/a/380154
9:52 PM ยท Dec 19, 2020
2
1
16
Some really awesome things this enables:
For ad-hoc exploration, just rough out the SQL and then use VisiData to figure out what you actually want. If you need to, _then_ go back to the SQL to implement your adjustments. It becomes a tool for helping you think!
1
0
1
Save the results in a variety of formats super quickly instead of fumbling with \pset format csv (or worse, \a) and \o.
1
0
0

