Contents
- Getting Started
- Deployment
- Login Dialog
- Enabling two-factor authentication (2FA)
- User Management Dialog
- Change Ownership Dialog
- Change User Password Dialog
- Lock/Restore Account
- Enabling LDAP Authentication
- Enabling Kerberos Authentication
- Enabling OAUTH2 Authentication
- Enabling Webserver Authentication
- User Interface
- Menu Bar
- Toolbar
- Tabbed Browser
- Tree Control
- Preferences Dialog
- Keyboard Shortcuts:
- Search objects
- External database for pgAdmin user settings
- Connecting To A Server
- Managing Cluster Objects
- Managing Database Objects
- Creating or Modifying a Table
- Management Basics
- Backup and Restore
- Developer Tools
- Processes
- pgAgent
- pgAdmin Project Contributions
- Release Notes
- Licence
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 |
Browser tree |
Shift+Alt+n |
Create object |
Shift+Alt+d |
Delete object |
Shift+Alt+m |
Delete/Drop multiple objects |
Shift+Ctrl+[ |
Dialog tab backward |
Shift+Ctrl+] |
Dialog tab forward |
Shift+Alt+g |
Direct debugging |
Shift+Alt+u |
Drop Cascade multiple objects |
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 browser tree |
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 |