DataGrip 2024.1 Help

Data Editor and Viewer

The settings on this page define how table data is shown and modified in your database consoles, data editors, and so on.

the Data Editor and Viewer settings dialog

Limitations

Option

Description

Limit page size to

Number of table rows that are shown on one page. If you do not want to limit the number of rows displayed simultaneously, clear the checkbox.

Also, you can change the page size by clicking the Change page size list of the pagination toolbar.

Consider the following example where Limit page size to is set to 2:

Limit page size to

Result set prefetch size

Number of rows from a database that is retrieved in one chunk.

A bigger number means less round trips between IDE and a database but more memory for storing a chunk.

Filter history size

Number of recently-used filtering conditions that are saved for a table in a data editor. Consider the following example where Filter history size is set to 2. The filter history box contains only two conditions.

To open the filter history in the editor, click the WHERE or ORDER BY field and press Alt+Down.

Filter history size

Maximum number of bytes loaded per value

Maximum size of a binary large object to be loaded in bytes.

Show first N data rows in preview

Limit number of rows for a quick documentation popup. To see quick documentation, press Ctrl+Q.

Data Presentation

Option

Description

Use custom font

Set the dedicated font for your data. The font is applied for query results and data editor, not for query consoles and your SQL files.

Custom font applied to the displayed data

Alternate row colors

Select this checkbox to make the table row colors alternate between two kinds of colors.

Alternating row colors

Show boolean values as

Set how you want to display boolean values in the data editor. You can select between the following options.

  • Text: boolean values are shown as text. White dots are displayed with the true values to help you distinguish them from the false ones.

    Display boolean values as text

    There are the following options of editing a boolean value that is shown as text:

    1. Double-click a cell and select a value from the drop-down list.

    2. To toggle the values, select a cell and press Space.

    3. To set a certain value, select a cell and type the value's first letter: f for false, t for true, d for default, n for null, g for generated, and c for computed.

  • Checkboxes: boolean values are shown as checkboxes. If the checkbox is selected, the value is true. If the checkbox is cleared, the value is false.

    Display boolean values as checkboxes

To set NULL or DEFAULT values, right-click a cell and select Set NULL or Set DEFAULT.

Automatically transpose tables

Configure when you want to transpose tables and views when you open them in the data editor. In a transposed view, columns and rows are interchanged. Note that this setting does not transpose query results.

  • Never: do not transpose a table.

  • If a table has one record: transpose only tables with a single record.

  • Always: always transpose tables.

Automatically detect binary values

Enables the default display type for binary values.

Display temporal data in time zone

Set the time zone to display the date and time data in.

Custom Number Formats

Option

Description

Decimal separator

Sets a symbol to be used as a decimal separator. Default: ..

Grouping separator

Sets a symbol to be used as a grouping separator.

Infinity

Defines the way infinity will be rendered.

NaN

Defines the way NaN will be rendered.

Number pattern

Enables and sets number patterns.

Data Sorting

For more information about data sorting, refer to the Sort data topic.

Option

Description

Sort via ORDER BY

Enables the default sorting method as sorting by sending the ORDER BY query each time you reopen the table.

Sort tables by numeric primary key

Configures how to sort table records by the numeric primary key. Two options is available: Ascending or Descending.

Add columns to sorting

Select what action to use when you want to add columns to stacked sorting. The default is Alt and a click.

When you click the column name, the column data is sorted. The column sorting is not stacked by default. It means that if you click a column name to sort data by, the sorting based on other columns will be cleared. If you prefer to use the stacked sorting, click a column name while pressing Alt.

Data Modification

Option

Description

Submit changes immediately

Submit changes instantly. For more information about submitting your changes to a database, refer to Submit changes to a database.

Custom Date/Time Formats

For the available date patterns, click Date patterns.

Option

Description

Datetime/timestamp

Select and set a custom datetime or timestamp format.

Datetime/timestamp with time zone

Select and set a custom datetime or timestamp format with time zone.

Time

Select and set a custom time format.

Time with time zone

Select and set a custom time format with time zone.

Date

Select and set a custom date format.

Time zone

Select the time zone in which the datetime value should be displayed.

Last modified: 17 June 2024