okbob / 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.
BSD 2-Clause "Simplified" License
2.48k stars 86 forks source link

Add support for additional outputs for PostgreSQL #163

Closed mjf closed 3 years ago

mjf commented 3 years ago

\d+ table

fr

It would be really nice if the extended/additional output under the data table view was handled differently as it is not part of the tabular data (i.e. switch off numbering and handle the whole block of lines containing the View definition: and forth as a single row or something alike).

okbob commented 3 years ago

po 12. 4. 2021 v 9:30 odesílatel Matouš Jan Fialka @.***> napsal:

\d+ table

[image: fr] https://user-images.githubusercontent.com/54104/114356402-d9f0a000-9b70-11eb-94d9-7e3c22ce00b4.png

It would be really nice if the extended/additional output under the data table view was handled differently as it is not part of the tabular data (i.e. switch off numbering and handle the whole block of lines containing the View definition: and forth as a single row or something alike).

It is handled differently. You can change separate colors for this area (backgrounds, cursor, ...) - unfortunately, in this case, you need to modify pspg source code - themes.c file

I am afraid so different counting of rows can be messy - usually one one row is in this area.

But maybe the used theme can be fixed - usually I design minimalistic themes with reduced colors

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/okbob/pspg/issues/163, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAEFO4YA5QDXP3NTKZZERPDTIKOTDANCNFSM42YWHOSQ .

okbob commented 3 years ago

po 12. 4. 2021 v 9:50 odesílatel Pavel Stehule @.***> napsal:

po 12. 4. 2021 v 9:30 odesílatel Matouš Jan Fialka < @.***> napsal:

\d+ table

[image: fr] https://user-images.githubusercontent.com/54104/114356402-d9f0a000-9b70-11eb-94d9-7e3c22ce00b4.png

It would be really nice if the extended/additional output under the data table view was handled differently as it is not part of the tabular data (i.e. switch off numbering and handle the whole block of lines containing the View definition: and forth as a single row or something alike).

It is handled differently. You can change separate colors for this area (backgrounds, cursor, ...) - unfortunately, in this case, you need to modify pspg source code - themes.c file

I am afraid so different counting of rows can be messy - usually one one row is in this area.

But maybe the used theme can be fixed - usually I design minimalistic themes with reduced colors

And try to use border 2 - it will be more readable, I hope - with border 1 the tabular output and footer content are not well separated

Pavel

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub https://github.com/okbob/pspg/issues/163, or unsubscribe https://github.com/notifications/unsubscribe-auth/AAEFO4YA5QDXP3NTKZZERPDTIKOTDANCNFSM42YWHOSQ .

mjf commented 3 years ago

And try to use border 2 - it will be more readable, I hope - with border 1 the tabular output and footer content are not well separated

$ grep border .pspgconf 
force_uniborder = true
border_type = 2

Update: ignore this comment because you obviously meant the \pset border 2. :smile:

okbob commented 3 years ago

please, check 314255491c05a77376222b5b885f28c433588570

okbob commented 3 years ago

fixed in 4.6.0