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 Object explorer
Shift+Alt+n Create object
Shift+Alt+d Delete object
Shift+Ctrl+[ Dialog tab backward
Shift+Ctrl+] Dialog tab forward
Shift+Alt+g Direct debugging
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 object explorer
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

Inner Tab and Panel Navigation

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

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