PyCharm
 
2022.3
Shortcuts: Windows
Get PyCharm
You are viewing the documentation for an earlier version of PyCharm.
  1. Database tools and SQL
  2. Data editor
  3. Work with data

Work with data

Last modified: 18 January 2023

Available only in PyCharm Professional: download to try or compare editions

warning

The following is only valid when the Database Tools and SQL plugin is installed and enabled.

Operations with columns in the structure view

The structure view displays you a list of all the columns in the selected table. The structure view is available in the Structure tool window (View | Tool Windows | Structure) or in the popup window (Ctrl+F12).

You can perform the following operations with columns:

  • Sort the data in the ascending Alt+Shift+Up or the descending order (Alt+Shift+Down).

  • Reset the state of sorting (Ctrl+Alt+Shift+Backspace).

  • Hide a column or show a hidden column (Space). The names of hidden columns are shown struck-through.

    Operations with columns in the structure view

tip

Right-click a cell in the table header row and select Columns List.

tip

Alternatively, to sort the column data, use the context menu.

Copy data to another database

  1. Double-click a table to open it in the data editor.

  2. Click the Copy to Database icon on the toolbar.

  3. Specify the database, target schema (to create a new table with the exported data) or table (to add exported data to an existing table).

  4. Configure the data mapping and settings for the target table.

    Copy data to another database

Edit data in INSERT statements as a table

  1. Select INSERT statements that you want to edit.

  2. Right-click the selection and click Edit as Table.

    Edit data in INSERT statements as a table

  3. In the table editor that opens, make necessary changes in the table cell. Press Enter to confirm.

Export data

Export to a file

  1. To export data to a file, perform one of the following actions:

    • Right-click a result set, a table, or a view, select Export Data.

    • Right-click a query and select Export Data to &File.

    • On the toolbar, click the Export Data icon (The Export Data icon) and select Export to File.

  2. In the Export Data dialog, click Export 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 Export Data icon (The Export Data icon) and select Copy To Clipboard.