Keyboard Shortcuts

Keyboard shortcuts are provided in pgAdmin to allow easy access to specific functions. The shortcuts can be configured through File > Preferences dialogue as per the need.

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

Main Browser Window

When using main browser window, the following keyboard shortcuts are available:

Shortcut for all platform Function
Alt+Shift+F Open the File menu
Alt+Shift+O Open the Object menu
Alt+Shift+L Open the Tools menu
Alt+Shift+H Open the Help menu
Alt+Shift+B Focus the browser tree
Alt+Shift+[ Alt+Shift+] Move tabbed panel backward/forward

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
<accesskey> + y <accesskey> + y Copy SQL on history panel

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
<accesskey> + y <accesskey> + y Copy SQL on history panel

Debugger

When using the Debugger, the following shortcuts are available:

Shortcut (Windows/Linux) Shortcut (Mac) Function
<accesskey> + i <accesskey> + i Step in
<accesskey> + o <accesskey> + o Step over
<accesskey> + c <accesskey> + c Continue/Restart
<accesskey> + t <accesskey> + t Toggle breakpoint
<accesskey> + x <accesskey> + x Clear all breakpoints
<accesskey> + s <accesskey> + s Stop
Alt + Shift + g Alt + Shift + g Enter or Edit values in Grid

Inner panel navigation

When using the Query Tool and Debugger, the following shortcuts are available for inner panel navigation:

Shortcut (Windows/Linux) Shortcut (Mac) Function
Alt + Shift + Right Arrow Alt + Shift + Right Arrow Move to next inner panel
Alt + Shift + Left Arrow Alt + Shift + Left Arrow Move to previous inner panel

Note

<accesskey> is browser and platform dependant. The following table lists the default access keys for supported browsers.

  Windows Linux Mac
Internet Explorer Alt Alt  
Chrome Alt Alt Ctrl+Alt
Firefox Alt+Shift Alt+Shift Ctrl+Alt
Safari Alt   Ctrl+Alt