search

kristijanhusak / vim-dadbod-ui

Simple UI for https://github.com/tpope/vim-dadbod
MIT License
1.54k stars 94 forks source link

Transpose output table #136

Closed antosha417 closed 2 years ago

antosha417 commented 2 years ago

Hi! I'm very exited about this plugin and enjoy using it!

Is it possible to transpose the table in the output window? Some of tables that I query have a lot of columns and it would be so much easier to scoll results from up to bottom, not from left to right.

I want the output to be something like this:

+-------+--------+--------+--------+
| id    | 1      | 2      | 3      |
+-------+--------+--------+--------+
| value | value1 | value2 | value3 |
+-------+--------+--------+--------+
...

Where id and value are column names. And the rest are values

kristijanhusak commented 2 years ago

I'm not sure which db are you using, but if you are using Postgres, you can use extended display view. It was broken, but I just pushed a fix. In the output window, press <Leader>R to switch to extended display. It's not exactly how you want it, but it shows column per each line.

antosha417 commented 2 years ago

Right now mostly I use mysql, I see that the feature must work there. You are right, that's not exactly what I had in mind, but it is still very good and saves me from horizontal scrolling! Maybe this format is even better for me

The only thing that bothers me is after update I have this error message on every search Screen Shot 2022-06-20 at 16 27 36

kristijanhusak commented 2 years ago

I just pushed an update that should fix that.

antosha417 commented 2 years ago

Thank you a lot for your help. You are super fast to respond

I think you can close this issue