Vertical/Expanded row display

[ahmedmohiduet]

Can I view records vertically with column names along side data?
It's like '\X' flag for `Expanded Display' in psql(PostgreSQL).
I am exploring Sql Server 2008 database

[kenshaw]

While I eventually intend to build out support for all the psql standard commands, this isn't high on my priority list. I'd welcome a PR for this, however. It would be fairly easy to implement.

[KeeonTabrizi]

fwiw, one of the first questions i thought of when seeing this project was if it supports expanded display

[nineinchnick]

I gave it a shot at xo/tblfmt#8 - if this is merged and go.mod is bumped no other changes are required. I tested this with:

% echo "replace github.com/xo/tblfmt => github.com/nineinchnick/tblfmt v0.0.0-20201223194615-db8a914c3ebe" >> go.mod
% go mod tidy
% go run . sqlite://:memory:
Connected with driver sqlite3 (SQLite3 3.31.1)
Type "help" for help.

sq::memory:=> select 1;
 1 
---
 1 
(1 row)

sq::memory:=> \x
Expanded display is on.
sq::memory:=> \pset border 2
Border style is 2.
sq::memory:=> select 2 as aaaaa, 5 as b;
+-[ RECORD 1 ]-+
| aaaaa | 2    |
| b     | 5    |
+-------+------+

[nineinchnick]

This is now in master and this issue can be closed.