result presentation as plain text

[frankmusolf]

[Serge]

Hello,

You can select cells,columns or entire grid and then use copy or advanced copy (ctrl+shift+c) to copy grid data into clipboard. Then you may paste it into Excel or in plain text editor.

Does it make sense to make additional tab or switcher just to get plain text version? I can't imagine why somebody might want it (except for exporting). But maybe I'm mising something.

[frankmusolf]

I use this feature and i like it.
It's a fast way to copy one or more column names, parts of column data, complete results including column names..

It comes from old times with execute sql from shell like sql plus for oracle.

best for me was a switch button beside 'Filters' button in COLUMNS tab to switch presenting mode.
so i can sort in table mode, switch to text mode and copy data to clipboard.

i like this feature so much - switch button can be used to switch default behavior not only for switching temporarily.

exellent was configurable column delimiters (nothing or comma) and encapsulating of string values with ''.

regards
Frank

[Serge]

You can select any number of cells, columns or rows (like in MS Excel) and then just copy them. If you need columns names or row numbers or you need a diferent delimiter (by default it is TAB) then you'd better use advanced copy function (ctrl+shift+c).
If you need more settings you may export resultset or table into csv/xml/html file (Export Result Set action in context menu).
So all features you described are already there.

I agree that for some people it may be more usual to use plain text (as it is implemented in a few DB managers) but in fact it is quite complex feature and I would prefer to do it only if it will bring new functionality.
Can you call a function that can not be done in the current UI?

Thanks!

[frankmusolf]

i think plain text is easy to use. nothing else.

i can access on column names and result values without thinking. it's fast like working with a good shell.

anyway.. dbeaver is exellent enough for loving it
thanks
frank

[Remy]

Sorry to revive this old topic, but i think the feature requested is really important. I registered just to post this.

I can think of several use cases when you'd like to see the results in plain text like the original poster requested.

For example, when you run a query which yields multiple resultsets (several select statements) and you want to see (and compare) them in the same tab. Or you want to copy all data at once. This is specially important when you didn't write the query yourself, such as like some internal stored procedures in SQL Server that return multiple result sets.

The most important example i can think of right now is the sp_help stored procedure, that i use like 100 times a day when querying a database i'm not familiar with. It returns information about tables, views and stored procedures, and yields several resultsets (columns, indexes, foreign keys, etc). The way dbeaver displays this results now (one in each tab) makes the results basically unusable, since i can't really see what's happening and the tabs themselves don't even have a title informing what's in each of them. If i could just set the display to plain text i'd be able to see all the resultsets at once, and quickly hit ctrl+f for example to search for a specific column name or index.

On a side note, it would be really nice to have shorcuts to show/hide the results pane (so i can use all the screen real state to edit my query) and another shortcut to switch between text and grid results.

Thanks.

[Serge]

Hi,

Ok, I agree that plain text results representation could be really useful. I'll raise priority of this feature.
I see two possibilities:
1. Reuse "Output" tab and print results there.
2. Make mode switcher which will toggle grid/plain text mode.
Not yet sure which one is better.

Regarding result panel show/hide - by double clicking on results tab you may maximize/restore it. Not exactly what you want but maybe helpful.

[Remy]

Hi Serge, and thank you very much for your reply and for raising the priority for this feature.
I think option 2, a mode switcher would be preferable, specially if it could be switched using a keyboard shortcut. That way you could quickly switch back and forth from text to grid, and rerun the query on that mode.

Also, thank you very much for the tip on the result panel. What i was actually looking for was a way to hide the result panel so i have more screen space to work on the query. I found tho that i can compromise by making the result panel really narrow (1 row height) while i'm working on the query, then i run it and double click the result panel to have it maximized. Not ideal, but a nice workaround. A shortcut for that would be even better tho (yeah, keyboard junkie here).

Again thank you very much for your help.

[Alphadexx]

Hi,

any news or release date on this feature?

Just started using Dbeaver and luving it!
I would really like to see plain text results implemented, I miss that a lot after using similar application.
For example, it would be great if both results are available at the same time, grid and plain text, just in different tab (or make it a choice).

Thank you and best regards

[frankmusolf]

Hi Serge,
best for this feature in my opinion was possibility to switch between table and plain text mode (also for existing results).
dbeaver should remember for last using and reuse this mode for next time.
regards from springtime in hamburg
frank