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
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+[ Move tabbed panel backward
Alt+Shift+] Move tabbed panel forward
Alt+Shift+Q Open the Query Tool in the current database
Alt+Shift+V View Data in the selected table/view
Alt+Shift+C Open the context menu
Alt+Shift+N Create an object
Alt+Shift+E Edit object properties
Alt+Shift+D Delete the object
Alt+Shift+G Direct debugging

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
F5 F5 Execute query
F6 F6 Save data changes
F7 F7 EXPLAIN query
Shift + F7 Shift + F7 EXPLAIN ANALYZE query
F8 F8 Execute query to CSV file
+ o + o Open file
+ s + s Save file
+ n + n Find option drop down
+ c + c Copy row(s)
+ p + p Paste row(s)
+ d + d Delete row(s)
+ f + f Filter dialog
+ i + i Filter options drop down
+ r + r Row limit
+ q + q Cancel query
+ l + l Clear option drop down
+ x + x Execute option drop down
+ t + t Display connection status
+ y + y Copy SQL on history panel

Debugger

When using the Debugger, the following shortcuts are available:

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

Inner Tab and 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 + ] Alt + Shift + ] Move to next tab within a panel
Alt + Shift + [ Alt + Shift + [ Move to previous tab within a panel
Alt + Shift + Tab Alt + Shift + Tab Move between inner panels

Access Key

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 + Option
Firefox Alt + Shift Alt + Shift Ctrl + Option
Safari Alt Ctrl + Option