Query console

, , , ,

First Page,

Previous Page Ctrl+Alt+Up,

Change page size,

Next Page Ctrl+Alt+Down,

Last Page

Use navigation icons and corresponding commands for switching between pages that show the retrieved data and change the page size.

A number of rows that you see on the Result tab are referred to as a result set page. If this number is less than the number of rows that satisfy the query, only a subset of all the rows is shown at a time. If all the rows are currently shown, navigation icons and the corresponding commands are inactive. You can see the limit between the navigation buttons. You can change it here by clicking and selecting the necessary limit or in settings.

• : jump to the first page of results.

• : go to the previous page of results.

• : go to the next page of results.

• : jump to the last page of results.

To change the size of a result set page, click the Change page size button and select the size. Alternatively, open settings (Ctrl+Alt+S) and navigate to Tools | Database | Data Editor and Viewer. In the Limit page size to field, type a new size of a result set page. Alternatively, to disable the page size restriction, clear the Limit page size to checkbox.

Reload Page

Ctrl+F5

Reload data for the table view to synchronize the data that you see in the editor with the contents of the database. Also, use the Reload Page button when you want to apply a new page size limit setting after its change.

Add Row

Alt+Insert

Add a row to the table.

To save a new row, click Submit .

The Add Row button is disabled in the inappropriate context. For example, if the current table does not permit adding rows.

For more information about working with rows, see Rows.

Delete Row

Ctrl+Y

Delete the selected row or rows.

To select multiple rows, click numbers in the gutter. Also, you can press Ctrl and click the necessary rows.

The Delete Row button is disabled in the inappropriate context. For example, if the current table does not permit removing rows.

Transaction Mode

and

Transaction Isolation

Select the isolation level for database transactions and the way the transactions are committed.

• Auto: the current transaction is committed automatically when you submit your local changes to the database server.

• Manual: the changes submitted to the database server are accumulated in a transaction that can either be committed or rolled back explicitly by means of the Commit () or Rollback () buttons on the toolbar.

For more information about database transaction modes and isolation, refer to Submit changes to a database.

Submit

Ctrl+Enter

Submit local changes to the database server. For more information about submitting and reverting changes, see Submit changes to a database.

Commit Ctrl+Alt+Shift+Enter

Commit the current transaction. See also, transaction modes and isolation.

Roll Back

Roll back changes. This button is available only for the manual transaction mode. See also, transaction modes and isolation.

Cancel Running Statements

Ctrl+F2

Terminate execution of the current statement or statements.

Compare Data

Compare the current table with a table from the list.

For more information about comparing tables, see Compare table data.

Pin Tab

Pin the tab to the tool window to keep the query result.

For more information about pinning tabs, see Pin the tab with query results.

Data Extractors

Select an output format for your data.

Also, you can configure the following options:

• Skip Computed Columns: do not include virtual columns that are not physically stored in the table (for example, the identity column).

• Skip Generated Columns: for INSERT and UPDATE statements, do not include auto-increment fields when copying or saving data.

• Configure CSV Formats: open the CSV Formats dialog where you can manage your delimiter-separated values formats (for example, CSV, TSV).

• Go To Scripts Directory: open a directory with scripts that convert table data into different output formats.

Export Data

Export the table data to the clipboard or save to a file.

Export to Database

Export the data to another table, schema, or database. In the Choose Target dialog, select the target schema (a new table is created) or table (the data is added to the selected table). In the Import Table dialog, customize mappings.

Show Options Menu

The Show Options Menu list includes the following options:

• Show Geo Viewer: enable a graphic viewer to explore geospatial data in your database.

  For more information about the Geo viewer, refer to Using Geo viewer for geographical data in PostgreSQL.

• Show Value Editor: open a separate editor where you can edit data that is stored in the cell.

  For more information about the editor, refer to Value editor.

• Show Aggregate View: open the aggregate view where you can select values of multiple cells and get a single summary value.

  For more information about the view, refer to Aggregate view.

• Paste Format: select how you want to treat the text from the clipboard on paste.

• Reset View: restore the initial table view if you customized the table view before (for example, hidden columns or sorted data).

• View Query: view the query that generated the table.

• Copy Query to Console: copy the query that generated the table to query console.

• Open Data View Settings...: open the Data Editor and Viewer section in settings, where you can define how table data are shown and modified in your query consoles and data editors.

  For more information about the Data Editor and Viewer settings section, refer to Data Editor and Viewer.