Fork me on GitHub

This page in other versions: Latest (8.12) | 8.11 | 8.10 | 7.8 | 6.21 | Development

This document in other formats: PDF | ePub | Tarball

Navigation

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 (Windows/Linux)

Shortcut (Mac)

Function

Shift + Ctrl + a

Shift + Ctrl + a

Add grid row

Shift + Alt + b

Shift + Option + b

Object explorer

Shift + Alt + n

Shift + Option + n

Create object

Shift + Alt + d

Shift + Option + d

Delete object

Shift + Alt + g

Shift + Option + g

Direct debugging

Shift + Alt + e

Shift + Option + e

Edit object properties

Shift + Alt + f

Shift + Option + f

File main menu

Shift + Alt + h

Shift + Option + h

Help main menu

Shift + Alt + o

Shift + Option + o

Object main menu

Shift + Alt + q

Shift + Option + q

Open query tool

Shift + Ctrl + f

Shift + Ctrl + f

Quick Search

F5

F5

Refresh object explorer

Shift + Alt + s

Shift + Option + s

Search objects

Shift + Alt + [

Shift + Option + [

Tabbed panel backward

Shift + Alt + ]

Shift + Option + ]

Tabbed panel forward

Shift + Alt + w

Shift + Ctrl + w

Close tab panel

Shift + Alt + l

Shift + Option + l

Tools main menu

Shift + Alt + v

Shift + Option + v

View data

Property Grid Controls

Use the shortcuts below when working with property grid controls:

Shortcut for all platforms

Function

Ctrl + 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

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/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

Ctrl + l

Cmd + l

Go to line, column

Ctrl + Space

Ctrl + Space

Auto-complete

Ctrl + f

Cmd + f

Find

Ctrl + Shift + f

Option + Cmd + f

Replace

Query Tool

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

Shortcut (Windows/Linux)

Shortcut (Mac)

Function

Ctrl + o

Cmd + o

Open file

Ctrl + s

Cmd + s

Save file

Alt + Shift + n

Option + Shift + n

Edit options

Alt + Shift + f

Option + Shift + f

Sort/Filter

Alt + Shift + i

Option + Shift + i

Filter options

Alt + Shift + q

Option + Shift + q

Cancel query

F5

F5

Execute Script

Alt + Shift + x

Option + Shift + x

Execute options

F7

F7

EXPLAIN query

Shift + F7

Shift + F7

EXPLAIN ANALYZE query

Shift + Ctrl + m

Shift + Ctrl + m

Commit

Shift + Ctrl + r

Shift + Ctrl + r

Rollback

Alt + Ctrl + a

Option + Ctrl + a

Add row

Ctrl + c

Cmd + c

Copy rows

Alt + Shift + p

Option + Shift + p

Paste rows

Alt + Shift + d

Option + Shift + d

Delete rows

F6

F6

Save data changes

Ctrl + Alt + L

Ctrl + option + L

Clear query

F8

F8

Download Results

Shift + Alt + ]

Shift + option + ]

Next tab

Shift + Alt + [

Shift + option + [

Previous tab

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

Alt + Shift + x

Option + Shift + x

Clear all breakpoints

Alt + Shift + c

Option + Shift + c

Continue/Start

Alt + Shift + i

Option + Shift + i

Step into

Alt + Shift + o

Option + Shift + o

Step over

Alt + Shift + s

Option + Shift + s

Stop

Alt + Shift + t

Option + Shift + t

Toggle breakpoint

Alt + Shift + q

Option + Shift + q

Edit grid values

Alt + Shift + ]

Option + Shift + ]

Next tab

Alt + Shift + [

Option + Shift + ]

Previous tab

Alt + Shift + Tab

Option + Shift + 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:

Shortcut (Windows/Linux)

Shortcut (Mac)

Function

Alt + Shift + ]

Option + Shift + ]

Move to next tab within a panel

Alt + Shift + [

Option + Shift + [

Move to previous tab within a panel

Alt + Shift + Tab

Option + Shift + Tab

Move between inner panels