Keyboard shortcuts are provided in pgAdmin to allow easy access to specific functions.

Desktop Runtime

When running in the Desktop Runtime, the following keyboard shortcuts are available:

Shortcut (Windows/Linux) Shortcut (Mac) Function
Alt+Shift+A Option+Shift+A Display the runtime’s About box
Alt+Shift+P Option+Shift+U Open the runtime preferences dialogue
Alt+Shift+U Option+Shift+U Open an arbitrary URL
Ctrl+Q Cmd+Q Quit
Ctrl+Plus Cmd+Plus Zoom in
Ctrl+Minus Cmd+Minus Zoom out
Ctrl+0 Cmd+0 Reset the zoom level

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

Query Tool

When using the Query Tool, the following shortcuts are available:

Shortcut (Windows/Linux) Shortcut (Mac) Function
F5 F5 Execute query
F7 F7 EXPLAIN query
Shift+F7 Shift+F7 EXPLAIN ANALYZE query
F8 F8 Execute query to CSV file
Alt+G Alt+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