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.
If you are happy to have the table structures as SQL CREATE statements, then you can just go to the navigator panel on the left, into “Tables”, select all the tables, then right click and Choose “Generate SQL” -> DDL
I use Windows 7, so maybe it doesn’t work the same way, but it is worth a try. First you have to install your local postgresql server. When this is done, it’s quite simple, just make a rightclick on your PostgreSQL connection and then click on “Edit Connection”. Here you can choose your local client. … Read more
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
On the connection, right-click -> Edit connection -> Connection settings -> on the tabbed panel, select PostgreSQL, check the box Show all databases.
Got to Preferences > General > Editors > SQL Editor > SQL Formatting. Then over under Auto Format there is a box for Convert Keyword Case.
You don’t need to use the clipboard, you can export directly the whole resultset (not just what you see) to a file : Execute your query Right click any anywhere in the results click “Export resultset…” to open the export wizard Choose the format you want (CSV according to your question) Review the settings in … Read more
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