Contents
- Getting Started
- Deployment
- Login Page
- 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 (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 + w |
Shift + Ctrl + w |
Close tab panel |
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:
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:
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:
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:
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:
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 |