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

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+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
Ctrl+Plus Cmd+Plus Zoom in
Ctrl+Minus Cmd+Minus Zoom out

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
Shift+Ctrl+G Shift+Cmd+G Find previous
Shift+Ctrl+F Shift+Cmd+F Replace
Shift+Ctrl+R Shift+Cmd+Option+F Replace all