File | Settings | Appearance & Behavior | Data Editor and Viewer for Windows and Linux
PyCharm | Appearance & Behavior | Data Editor and Viewer for macOS
The settings on this page define how table data is shown and modified in your database consoles, data editors, and so on.
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.
Alternate row colors
Select this checkbox to make the table row colors alternate between two kinds of 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.
There are the following options of editing a boolean value that is shown as text:
Double-click a cell and select a value from the drop-down list.
To toggle the values, select a cell and press Space.
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.
To set NULL or DEFAULT values, right-click a cell and select Set NULL or Set DEFAULT.
