I have faced the same issue, when added a column from script and tried to update data on table from UI. it can solved by disconnecting and connecting to database as DBeaver currently don’t refresh the DDLs.
And 30 seconds after posting I found the answer. There is an SQL Editor menu appeared at the top of the screen (not in the Database Navigator). Selecting SQL Editor from that brings up a query window I can type SQL into.
For larger files, the more optimally it is edit the .sql file in an external editor and then in DBeaver: right-click on your DB chose Tools / Execute script load your .sql file click Start. This approach is generally more convenient and faster for large files. To do this without an external editor, you must: … Read more
It is under Window / Preferences / Editors / Text Editors: In older versions it was under Window / Preferences / General / Editors / Text Editors. But as @simhumileco pointed out, there is a shortcut in the context menu when you right-click the left gutter of the editor.
I just migrated some projects from DBeaver 6.1.4 to 7.2.3 and the File > Export/Import options worked flawlessly. The full workflow is: File > Export, under “DBeaver”, select “Project”, click Next Select the projects to export and click Finish Copy the output file (by default, it is generated in home folder) into the machine where … Read more
Got to Preferences > General > Editors > SQL Editor > SQL Formatting. Then over under Auto Format there is a box for Convert Keyword Case.
For DBeaver 6.1.3+ The credential file is located ~/Library/DBeaverData/workspace6/General/.dbeaver/credentials-config.json (I was on Mac) and it follows a different encryption strategy than it’s predecessors. Please refer the next answer to see how to decrypt. It works like a charm. Pre- DBeaver 6.1.3 Follow these steps (My DBeaver version was 3.5.8 and it was on Mac OsX … Read more