Result Set is usually a result of some query execution or is the content of some table or view.
Result Set viewer. You may copy any number of cells, select columns, rows, all cells. The Result Set may be filtered and ordered by user defined criteria. Table content and query results may be edited.
Result Set viewer has two visualization modes: grid and record.
Grid mode (default) is a typical grid, similar to Excel. Grid mode shows only one record at a time and has two columns - database column name and column value. Use editor the toolbar or the TAB key to switch between these modes.
To navigate through rows and columns use standard navigation keys: cursor, PgUp, PgDown, Home, End. CTRL+End navigates to the last row, CTRL+Home to the first, etc.
Number of rows limited by viewer. Maximum number of rows (default value is 200) can be configured (in Preferences or in main toolbar). If you scroll to the last row, and it is possible to fetch new portion of rows, then DBeaver will automatically fetch the data and scroll down.
You may select any number of cells with mouse in combination with CTRL and SHIFT keys. Selected cells can be copied in clipboard in tab delimited format (and then pasted into Excel, Calc, etc).
Result Set can be exported in file. This command is accessible from context menu. Export wizard supports multiple export formats and big number of options. Export will fetch all rows from source query or table (could take a long time).
Note: DBeaver opens a separate database connection for export. It allows user to continue work with database while export is processed.
Result set can be ordered by one or many columns. Click on the arrow image next to the column name to order by this column. More ordering options are available in the Filter dialog.
Filtering and ordering options can be specified in Filter dialog. It is accessible from context menu or by clicking in the left upper corner of grid.
Read more about Data Filter Dialog.
Note: ordering/filtering of huge result set could take a lot of time, especially if you order/filter by non-indexed columns. Be careful when specifying order/filter criteria.
Table content and the result of some queries can be edited. Double click on grid cell opens cell editor dialog or LOB editor window. Pressing ENTER key on certain cell opens inline editor, another ENTER in cell editor saves changed value. You may navigate cell editors with TAB and SHIFT+TAB keys. Resultset grid fully supports clipboard operations - you may paste value into certain cell directly from clipboard.
Query result set edits are supported only if the database driver supports additional result set metadata (at the moment it was found and tested only in MySQL) and query results contain a combination of columns which constructs a unique key.
Table content edit is enabled if table has at least one unique key or index.
Cell edit dialog is accessible from the context menu. In-line editing is accessible from the toolbar (or press CTRL+ALT+S). To revert changes press the "Reject Changes" button (or press CTRL+ALT+R).
Note: if you work in transaction mode (autocommit is off) then you need to commit changes in the current connection (command accessible from main toolbar or main menu).