Page History

DBeaver User Guide

How do I restore my view of Navigator, Projects, and the SQL Editor?

It is easy to accidentally close these views without a clear way to restore them. To restore them quickly, choose Window/Open Perspective/Other/DBeaver (default)

Automated Tasks

Automating SQL script to run on a schedule

1. Right click on DBeaver project folder that contains the script to be automated and choose Set Active Project
2. Create new task, choose SQL script, choose the sql script file to run, choose Connection to use
3. Use the Scheduler to run the task on a given schedule in both DBeaver and Windows Task Scheduler
4. If you don't see the file you created in one of the local schemas right away, right-click on the Connection used and choose Refresh

How do I restore the column headers (e.g., Name, Database, Modified date) to the Scripts list?

From the Windows dropdown menu, choose "Project Explorer." The column headers reappear.

I am having trouble with permissions when I publish tables to local schemas. I cannot see the tables.

Try deleting your Postgresql database Connection Settings (for Metadb) and recreating the connection by re-entering all your settings. Be sure "show all databases" is checked next to the database field on the Main tab in your Connection Settings.

How do I show line numbers in my SQL Editor window?

Right-click the left margin of the SQL editor (gutter area). Select Show Line Numbers from the context menu.

Also, see...

https://www.developerscoffee.com/blog/optimizing-dbeaver-for-better-performance-and-usability/Scheduling automated Excel reports with Dbeaver.pdf