Keyboard Shortcuts:¶
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:
Shortcut for all platforms | Function |
---|---|
Shift+Ctrl+a | Add grid row |
Shift+Alt+b | Object explorer |
Shift+Alt+n | Create object |
Shift+Alt+d | Delete object |
Shift+Ctrl+[ | Dialog tab backward |
Shift+Ctrl+] | Dialog tab forward |
Shift+Alt+g | Direct debugging |
Shift+Alt+e | Edit object properties |
Shift+Alt+f | File main menu |
Shift+Alt+h | Help main menu |
Shift+Alt+o | Object main menu |
Shift+Alt+c | Open context menu |
Shift+Alt+q | Open query tool |
Shift+Ctrl+f | Quick Search |
F5 | Refresh object explorer |
Shift+Alt+s | Search objects |
Shift+Alt+[ | Tabbed panel backward |
Shift+Alt+] | Tabbed panel forward |
Shift+Alt+l | Tools main menu |
Shift+Alt+v | View data |
Dialog Tabs¶
Use the shortcuts below to navigate the tabsets on dialogs:
Shortcut for all platforms | Function |
---|---|
Control+Shift+[ | Dialog tab backward |
Control+Shift+] | Dialog tab forward |
Property Grid Controls¶
Use the shortcuts below when working with property grid controls:
Shortcut for all platforms | Function |
---|---|
Control+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 |
Control+Shift+A | Add row in Grid |
SQL Editors¶
When using the syntax-highlighting SQL editors, the following shortcuts are available:
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 selected code (Inline) |
Ctrl + . | Cmd + . | Uncomment selected code (Inline) |
Ctrl + Shift + / | Cmd + Shift + / | 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 |
Alt + g | Option + g | Jump (to line:column) |
Ctrl + Space | Ctrl + Space | Auto-complete |
Ctrl + f | Cmd + f | Find |
Ctrl + g | Cmd + g | Find next |
Ctrl + Shift + g | Cmd + Shift + g | Find previous |
Ctrl + Shift + f | Cmd + Shift + f | Replace |
Query Tool¶
When using the Query Tool, the following shortcuts are available:
Shortcut (Windows/Linux) | Shortcut (Mac) | Function |
---|---|---|
<accesskey> + q | <accesskey> + q | Cancel query |
<accesskey> + t | <accesskey> + t | Connection status |
<accesskey> + d | <accesskey> + d | Delete rows |
<accesskey> + x | <accesskey> + x | Execute options |
<accesskey> + f | <accesskey> + f | Filter dialog |
<accesskey> + i | <accesskey> + i | Filter options |
<accesskey> + n | <accesskey> + n | Find options |
<accesskey> + o | <accesskey> + o | Open file |
<accesskey> + p | <accesskey> + p | Paste rows |
<accesskey> + r | <accesskey> + r | Rows limit |
<accesskey> + s | <accesskey> + s | Save file |
Ctrl + Alt + L | Ctrl + option + L | Clear query |
Shift + Ctrl + m | Shift + Ctrl + m | Commit |
F8 | F8 | Download Results |
Shift + F7 | Shift + F7 | EXPLAIN ANALYZE query |
F7 | F7 | EXPLAIN query |
F5 | F5 | Execute query |
Shift + Alt + ] | Shift + option + ] | Next tab |
Shift + Alt + [ | Shift + option + [ | Previous tab |
Shift + Ctrl + r | Shift + Ctrl + r | Rollback |
F6 | F6 | Save data changes |
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:
Shortcut (Windows/Linux) | Shortcut (Mac) | Function |
---|---|---|
<accesskey> + x | <accesskey> + x | Clear all breakpoints |
<accesskey> + c | <accesskey> + c | Continue/Start |
<accesskey> + i | <accesskey> + i | Step into |
<accesskey> + o | <accesskey> + o | Step over |
<accesskey> + s | <accesskey> + s | Stop |
<accesskey> + t | <accesskey> + t | Toggle breakpoint |
Shift + Alt + q | Shift + option + q | Edit grid values |
Shift + Alt + ] | Shift + option + ] | Next tab |
Shift + Alt + [ | Shift + option + ] | Previous tab |
Shift + Alt + Tab | Shift + option +Tab | Switch Panel |
ERD Tool¶
When using the ERD Tool, the following shortcuts are available:
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 |
Access Key¶
<accesskey> is browser and platform dependant. The following table lists the default access keys for supported browsers.
Windows | Linux | Mac | |
---|---|---|---|
Edge | Alt | ||
Chrome | Alt | Alt | Ctrl + Option |
Firefox | Alt + Shift | Alt + Shift | Ctrl + Option |
Safari | Alt | Ctrl + Option |