This page in other versions: Latest (4.13) | 4.12 | 4.11 | 4.10 | Development

This document in other formats: PDF | ePub | Tarball

Navigation

Query Tool Toolbar

The Query Tool toolbar uses context-sensitive icons that provide shortcuts to frequently performed tasks. If an icon is highlighted, the option is enabled; if the icon is grayed-out, the task is disabled.

Note

The Query Tool and View/Edit Data tools are actually different operating modes of the same tool. Some controls will be disabled in either mode.

Query tool toolbar

Hover over an icon in pgAdmin to display a tooltip that describes the icon’s functionality.

File Options

Icon

Behavior

Shortcut

Open File

Click the Open File icon to display a previously saved query in the SQL Editor.

Accesskey + O

Save File

Click the Save icon to perform a quick-save of a previously saved query, or to access the Save menu:

  • Select Save to save the selected content of the SQL Editor panel in a file.

  • Select Save As to open a new browser dialog and specify a new location to which to save the selected content of the SQL Editor panel.

Accesskey + S

Editing Options

Icon

Behavior

Shortcut

Save Data

Click the Save Data icon to save data changes in the Data Output Panel to the server.

F6

Find

Use the Find menu to search, replace, or navigate the code displayed in the SQL Editor:

Select Find to provide a search target, and search the SQL Editor contents.

Cmd+F

Select Find next to locate the next occurrence of the search target.

Cmd+G

Select Find previous to move to the last occurrence of the search target.

Cmd+Shift+G

Select Pesistent find to identify all occurrences of the search target within the editor.

Select Replace to locate and replace (with prompting) individual occurrences of the target.

Cmd+Shift+F

Select Replace all to locate and replace all occurrences of the target within the editor.

Select Jump to navigate to the next occurrence of the search target.

Alt+G

Copy

Click the Copy icon to copy the content that is currently highlighted in the Data Output panel.

Accesskey + C

Paste

Click the Paste icon to paste a previously row into a new row.

Accesskey + P

Delete

Click the Delete icon to delete the selected rows.

Accesskey + D

Edit

Use options on the Edit menu to access text editing tools; the options operate on the text displayed in the SQL Editor panel when in Query Tool mode:

Select Indent Selection to indent the currently selected text.

Tab

Select Unindent Selection to remove indentation from the currently selected text.

Shift+Tab

Select Inline Comment Selection to enclose any lines that contain the selection in SQL style comment notation.

Cmd+/

Select Inline Uncomment Selection to remove SQL style comment notation from the selected line.

Cmd+.

Select Block Comment to enclose all lines that contain the selection in C style comment notation. This option acts as a toggle.

Shift+Cmd+/

View/Edit Data Resultset Control

Icon

Behavior

Shortcut

Filter

Click the Filter icon to set filtering and sorting criteria for the data when in View/Edit data mode. Click the down arrow to access other filtering and sorting options:

  • Click Sort/Filter to open the sorting and filtering dialogue.

  • Click Filter by Selection to show only the rows containing the values in the selected cells.

  • Click Exclude by Selection to show only the rows that do not contain the values in the selected cells.

  • Click Remove Sort/Filter to remove any previously selected sort or filtering options.

Accesskey + F

Limit Selector

Select a value in the Limit Selector to limit the size of the dataset to a number of rows.

Accesskey + R

Stop

Click the Stop icon to cancel the execution of the currently running query.

Accesskey + Q

Query Execution

Icon

Behavior

Shortcut

Execute/Refresh

Click the Execute/Refresh icon to either execute or refresh the query highlighted in the SQL editor panel. Click the down arrow to access other execution options:

  • Add a check next to Auto-Rollback to instruct the server to automatically roll back a transaction if an error occurs during the transaction.

  • Add a check next to Auto-Commit to instruct the server to automatically commit each transaction. Any changes made by the transaction will be visible to others, and durable in the event of a crash.

F5

Explain

Click the Explain icon to view an explanation plan for the current query. The result of the EXPLAIN is displayed graphically on the Explain tab of the output panel, and in text form on the Data Output tab.

F7

Explain analyze

Click the Explain analyze icon to invoke an EXPLAIN ANALYZE command on the current query.

Navigate through the Explain Options menu to select options for the EXPLAIN command:

  • Select Verbose to display additional information regarding the query plan.

  • Select Costs to include information on the estimated startup and total cost of each plan node, as well as the estimated number of rows and the estimated width of each row.

  • Select Buffers to include information on buffer usage.

  • Select Timing to include information about the startup time and the amount of time spent in each node of the query.

Shift+F7

Commit

Click the Commit icon to commit the transaction.

Shift+CTRL+M

Rollback

Click the Rollback icon to rollback the transaction.

Shift+CTRL+R

Clear

Use options on the Clear drop-down menu to erase display contents:

  • Select Clear Query Window to erase the content of the SQL Editor panel.

  • Select Clear History to erase the content of the History tab.

Accesskey + L

Download as CSV

Click the Download as CSV icon to download the result set of the current query to a comma-separated list. You can specify the CSV settings through Preferences -> SQL Editor -> CSV output dialogue.

F8