mirror of
https://github.com/pgadmin-org/pgadmin4.git
synced 2024-07-04 11:33:52 -05:00
281 lines
19 KiB
ReStructuredText
281 lines
19 KiB
ReStructuredText
****************************
|
|
`Keyboard Shortcuts`:index::
|
|
****************************
|
|
|
|
Keyboard shortcuts are provided in pgAdmin to allow easy access to specific
|
|
functions. Alternate shortcuts can be configured through File > Preferences if
|
|
desired.
|
|
|
|
Main Browser Window
|
|
*******************
|
|
|
|
When using main browser window, the following keyboard shortcuts are available:
|
|
|
|
.. table::
|
|
:class: longtable
|
|
:widths: 2 2 3
|
|
|
|
+----------------------------+--------------------+------------------------------------+
|
|
| Shortcut (Windows/Linux) | Shortcut (Mac) | Function |
|
|
+============================+====================+====================================+
|
|
| Shift + Ctrl + a | Shift + Ctrl + a | Add grid row |
|
|
+----------------------------+--------------------+------------------------------------+
|
|
| Shift + Alt + b | Shift + Option + b | Object explorer |
|
|
+----------------------------+--------------------+------------------------------------+
|
|
| Shift + Alt + n | Shift + Option + n | Create object |
|
|
+----------------------------+--------------------+------------------------------------+
|
|
| Shift + Alt + d | Shift + Option + d | Delete object |
|
|
+----------------------------+--------------------+------------------------------------+
|
|
| Shift + Alt + g | Shift + Option + g | Direct debugging |
|
|
+----------------------------+--------------------+------------------------------------+
|
|
| Shift + Alt + e | Shift + Option + e | Edit object properties |
|
|
+----------------------------+--------------------+------------------------------------+
|
|
| Shift + Alt + f | Shift + Option + f | File main menu |
|
|
+----------------------------+--------------------+------------------------------------+
|
|
| Shift + Alt + h | Shift + Option + h | Help main menu |
|
|
+----------------------------+--------------------+------------------------------------+
|
|
| Shift + Alt + o | Shift + Option + o | Object main menu |
|
|
+----------------------------+--------------------+------------------------------------+
|
|
| Shift + Alt + q | Shift + Option + q | Open query tool |
|
|
+----------------------------+--------------------+------------------------------------+
|
|
| Shift + Ctrl + f | Shift + Ctrl + f | Quick Search |
|
|
+----------------------------+--------------------+------------------------------------+
|
|
| F5 | F5 | Refresh object explorer |
|
|
+----------------------------+--------------------+------------------------------------+
|
|
| Shift + Alt + s | Shift + Option + s | Search objects |
|
|
+----------------------------+--------------------+------------------------------------+
|
|
| Shift + Alt + [ | Shift + Option + [ | Tabbed panel backward |
|
|
+----------------------------+--------------------+------------------------------------+
|
|
| Shift + Alt + ] | Shift + Option + ] | Tabbed panel forward |
|
|
+----------------------------+--------------------+------------------------------------+
|
|
| Shift + Alt + l | Shift + Option + l | Tools main menu |
|
|
+----------------------------+--------------------+------------------------------------+
|
|
| Shift + Alt + v | Shift + Option + v | View data |
|
|
+----------------------------+--------------------+------------------------------------+
|
|
|
|
Property Grid Controls
|
|
**********************
|
|
|
|
Use the shortcuts below when working with property grid controls:
|
|
|
|
.. table::
|
|
:class: longtable
|
|
:widths: 2 3
|
|
|
|
+----------------------------+-------------------------------------------------------+
|
|
| Shortcut for all platforms | Function |
|
|
+============================+=======================================================+
|
|
| Ctrl + Shift + A | Add row in Grid |
|
|
+----------------------------+-------------------------------------------------------+
|
|
| Tab | Move focus to the next control |
|
|
+----------------------------+-------------------------------------------------------+
|
|
| Shift + Tab | Move focus to the previous control |
|
|
+----------------------------+-------------------------------------------------------+
|
|
| Return | Pick the selected an item in a combo box |
|
|
+----------------------------+-------------------------------------------------------+
|
|
|
|
SQL Editors
|
|
***********
|
|
|
|
When using the syntax-highlighting SQL editors, the following shortcuts are available:
|
|
|
|
.. table::
|
|
:class: longtable
|
|
:widths: 2 2 3
|
|
|
|
+--------------------------+----------------------+-------------------------------------+
|
|
| Shortcut (Windows/Linux) | Shortcut (Mac) | Function |
|
|
+==========================+======================+=====================================+
|
|
| Alt + Left | Option + Left | Move to the beginning of the line |
|
|
+--------------------------+----------------------+-------------------------------------+
|
|
| Alt + Right | Option + Right | Move to the end of the line |
|
|
+--------------------------+----------------------+-------------------------------------+
|
|
| Ctrl + Alt + Left | Cmd + Option + Left | Move left one word |
|
|
+--------------------------+----------------------+-------------------------------------+
|
|
| Ctrl + Alt + Right | Cmd + Option + Right | Move right one word |
|
|
+--------------------------+----------------------+-------------------------------------+
|
|
| Ctrl + / | Cmd + / | Comment/Uncomment code (Block) |
|
|
+--------------------------+----------------------+-------------------------------------+
|
|
| Ctrl + a | Cmd + a | Select all |
|
|
+--------------------------+----------------------+-------------------------------------+
|
|
| Ctrl + c | Cmd + c | Copy selected text to the clipboard |
|
|
+--------------------------+----------------------+-------------------------------------+
|
|
| Ctrl + r | Cmd + r | Redo last edit un-done |
|
|
+--------------------------+----------------------+-------------------------------------+
|
|
| Ctrl + v | Cmd + v | Paste text from the clipboard |
|
|
+--------------------------+----------------------+-------------------------------------+
|
|
| Ctrl + z | Cmd + z | Undo last edit |
|
|
+--------------------------+----------------------+-------------------------------------+
|
|
| Tab | Tab | Indent selected text |
|
|
+--------------------------+----------------------+-------------------------------------+
|
|
| Shift + Tab | Shift + Tab | Un-indent selected text |
|
|
+--------------------------+----------------------+-------------------------------------+
|
|
| Ctrl + l | Cmd + l | Go to line, column |
|
|
+--------------------------+----------------------+-------------------------------------+
|
|
| Ctrl + Space | Ctrl + Space | Auto-complete |
|
|
+--------------------------+----------------------+-------------------------------------+
|
|
| Ctrl + f | Cmd + f | Find |
|
|
+--------------------------+----------------------+-------------------------------------+
|
|
| Ctrl + Shift + f | Option + Cmd + f | Replace |
|
|
+--------------------------+----------------------+-------------------------------------+
|
|
|
|
Query Tool
|
|
**********
|
|
|
|
When using the Query Tool, the following shortcuts are available:
|
|
|
|
.. table::
|
|
:class: longtable
|
|
:widths: 2 2 3
|
|
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
| Shortcut (Windows/Linux) | Shortcut (Mac) | Function |
|
|
+==========================+=======================+===================================+
|
|
| Ctrl + o | Cmd + o | Open file |
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
| Ctrl + s | Cmd + s | Save file |
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
| Alt + Shift + n | Option + Shift + n | Edit options |
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
| Alt + Shift + f | Option + Shift + f | Sort/Filter |
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
| Alt + Shift + i | Option + Shift + i | Filter options |
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
| Alt + Shift + q | Option + Shift + q | Cancel query |
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
| F5 | F5 | Execute Script |
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
| Alt + Shift + x | Option + Shift + x | Execute options |
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
| F7 | F7 | EXPLAIN query |
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
| Shift + F7 | Shift + F7 | EXPLAIN ANALYZE query |
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
| Shift + Ctrl + m | Shift + Ctrl + m | Commit |
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
| Shift + Ctrl + r | Shift + Ctrl + r | Rollback |
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
| Alt + Ctrl + a | Option + Ctrl + a | Add row |
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
| Ctrl + c | Cmd + c | Copy rows |
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
| Alt + Shift + p | Option + Shift + p | Paste rows |
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
| Alt + Shift + d | Option + Shift + d | Delete rows |
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
| F6 | F6 | Save data changes |
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
| Ctrl + Alt + L | Ctrl + option + L | Clear query |
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
| F8 | F8 | Download Results |
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
| Shift + Alt + ] | Shift + option + ] | Next tab |
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
| Shift + Alt + [ | Shift + option + [ | Previous tab |
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
| Shift + Alt + Tab | Shift + option + Tab | Switch Panel |
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
| Shift + Ctrl + u | Shift + Ctrl + u | Toggle case of selected text |
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
|
|
Debugger
|
|
********
|
|
|
|
When using the Debugger, the following shortcuts are available:
|
|
|
|
.. table::
|
|
:class: longtable
|
|
:widths: 2 2 3
|
|
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
| Shortcut (Windows/Linux) | Shortcut (Mac) | Function |
|
|
+==========================+=======================+===================================+
|
|
| Alt + Shift + x | Option + Shift + x | Clear all breakpoints |
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
| Alt + Shift + c | Option + Shift + c | Continue/Start |
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
| Alt + Shift + i | Option + Shift + i | Step into |
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
| Alt + Shift + o | Option + Shift + o | Step over |
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
| Alt + Shift + s | Option + Shift + s | Stop |
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
| Alt + Shift + t | Option + Shift + t | Toggle breakpoint |
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
| Alt + Shift + q | Option + Shift + q | Edit grid values |
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
| Alt + Shift + ] | Option + Shift + ] | Next tab |
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
| Alt + Shift + [ | Option + Shift + ] | Previous tab |
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
| Alt + Shift + Tab | Option + Shift + Tab | Switch Panel |
|
|
+--------------------------+-----------------------+-----------------------------------+
|
|
|
|
ERD Tool
|
|
********
|
|
|
|
When using the ERD Tool, the following shortcuts are available:
|
|
|
|
.. table::
|
|
:class: longtable
|
|
:widths: 2 2 3
|
|
|
|
+--------------------------+--------------------+-----------------------------------+
|
|
| Shortcut (Windows/Linux) | Shortcut (Mac) | Function |
|
|
+==========================+====================+===================================+
|
|
| Ctrl + Alt + a | Ctrl + option + a | Add table |
|
|
+--------------------------+--------------------+-----------------------------------+
|
|
| Ctrl + Alt + n | Ctrl + option + n | Add/Edit note |
|
|
+--------------------------+--------------------+-----------------------------------+
|
|
| Ctrl + Alt + l | Ctrl + option + l | Auto align |
|
|
+--------------------------+--------------------+-----------------------------------+
|
|
| Ctrl + Alt + c | Ctrl + option + c | Clone table |
|
|
+--------------------------+--------------------+-----------------------------------+
|
|
| Ctrl + Alt + i | Ctrl + option + i | Download image |
|
|
+--------------------------+--------------------+-----------------------------------+
|
|
| Ctrl + Alt + d | Ctrl + option + d | Drop table |
|
|
+--------------------------+--------------------+-----------------------------------+
|
|
| Ctrl + Alt + e | Ctrl + option + e | Edit table |
|
|
+--------------------------+--------------------+-----------------------------------+
|
|
| Ctrl + Alt + s | Ctrl + option + s | Generate SQL |
|
|
+--------------------------+--------------------+-----------------------------------+
|
|
| Ctrl + Alt + m | Ctrl + option + m | Many to many link |
|
|
+--------------------------+--------------------+-----------------------------------+
|
|
| Ctrl + Alt + o | Ctrl + option + o | One to many link |
|
|
+--------------------------+--------------------+-----------------------------------+
|
|
| Ctrl + o | Ctrl + o | Open project |
|
|
+--------------------------+--------------------+-----------------------------------+
|
|
| Ctrl + s | Ctrl + s | Save project |
|
|
+--------------------------+--------------------+-----------------------------------+
|
|
| Shift + Ctrl + s | Shift + Ctrl + s | Save project as |
|
|
+--------------------------+--------------------+-----------------------------------+
|
|
| Ctrl + Alt + t | Ctrl + option + t | Show more/fewer details |
|
|
+--------------------------+--------------------+-----------------------------------+
|
|
| Shift + Alt + + | Shift + option + + | Zoom in |
|
|
+--------------------------+--------------------+-----------------------------------+
|
|
| Shift + Alt + - | Shift + option + - | Zoom out |
|
|
+--------------------------+--------------------+-----------------------------------+
|
|
| Shift + Alt + f | Shift + option + f | Zoom to fit |
|
|
+--------------------------+--------------------+-----------------------------------+
|
|
|
|
Inner Tab and Panel Navigation
|
|
******************************
|
|
|
|
When using the Query Tool and Debugger, the following shortcuts are available
|
|
for inner panel navigation:
|
|
|
|
.. table::
|
|
:class: longtable
|
|
:widths: 2 2 3
|
|
|
|
+--------------------------+---------------------------+------------------------------------+
|
|
| Shortcut (Windows/Linux) | Shortcut (Mac) | Function |
|
|
+==========================+===========================+====================================+
|
|
| Alt + Shift + ] | Option + Shift + ] | Move to next tab within a panel |
|
|
+--------------------------+---------------------------+------------------------------------+
|
|
| Alt + Shift + [ | Option + Shift + [ | Move to previous tab within a panel|
|
|
+--------------------------+---------------------------+------------------------------------+
|
|
| Alt + Shift + Tab | Option + Shift + Tab | Move between inner panels |
|
|
+--------------------------+---------------------------+------------------------------------+
|
|
|