Dbeaver notes-shortcut key articles

The company is using the PostgreSQL database, which can be connected using pgadmin or Dbeaver. Individuals prefer to use dbeaver, because the interface is more beautiful and the operation is relatively simple.

Dbeaver is a general-purpose database management tool and SQL client that supports MySQL, PostgreSQL, Oracle, DB2, MSSQL, Sybase, Mimer, HSQLDB, Derby, and other JDBC-compatible databases.

Dbeaver provides a graphical interface to view the structure of the database, execute SQL queries and scripts, browse and export data, process BLOB/CLOB data, modify the database structure, and so on. shortcut keys for common use

1, Ctrl + Enter

Moving the cursor to any row, and then pressing the key combination executes the SQL statement for that line, and if you select a part of the SQL directly with your cursor, and then press the key combination, you do not execute the full SQL statement, but only the part of the SQL statement that you selected.

2, Ctrl + Alt + F

This combination can format the SQL statement, and when your SQL statement is long, you can format the SQL statement by using the combination key, which automatically renders each column and condition and so on, and finally presents a more viewed SQL statement.