Work with query results
When you run a query in the console, you receive results in the table format. Each statement appears in a separate tab in the Database Console tool window. For example, if you have two SELECT statements in the query, you will see two tabs in the tool window.
Open a new tab for each query
By default, PyCharm updates the same tab with results each time you run a query. You can change this behavior and create a tab each time you run a query.
In the IDE settings (Ctrl+Alt+S), go to .
Select the Open results in new tab checkbox and click OK.
Edit values in the result set
In the result set, click a cell value that you want to edit.
Specify a new value and press Enter.
To submit changes to a database, click the Submit icon (), or press Ctrl+Enter.
Export to a file
Right-click a, select.
Right-click a query, click Execute to File and select the file type that you want to use for export (for example, Comma-separated (CSV)).
On the toolbar, click the Dump Data icon () and select To File.
Export to a clipboard
Select data in the result set or in the editor and press Ctrl+C.
On the toolbar, click the Dump Data icon () and select To Clipboard.
Compare two result sets
Select a result set.
Click the Compare with icon (), and select another result set.
If needed, change a value of the Tolerance parameter in the comparison dialog. The Tolerance parameter defines a maximum number of differences that are allowed between two result sets. For example, if you want to consider two rows as equal if their data differs in a single column, enter
1in the Tolerance field.