PyCharm
 
2022.3
Shortcuts: Windows
Get PyCharm
You are viewing the documentation for an earlier version of PyCharm.
  1. Database tools and SQL
  2. Database objects
  3. Tables
  4. Export

Export

Last modified: 05 December 2022

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.

You can copy table data to the clipboard or save it in a file. The data is converted into one of the available output formats. As an output format, you can select SQL INSERT or UPDATE statements, TSV or CSV, an HTML table or JSON data.

Also, you can create a copy of a table in the schema of the current data source or select another data source and create a copy here.

Export a table to a file

  • Open a table or a result set, click the Export Data icon (The Export Data icon) and click Export To File.

    Export a view to a file

Export a table to a clipboard

  • On the toolbar, click the Export Data icon (The Export Data icon) and select Copy To Clipboard.

Configure data output format and options

  • You can configure how extracted data is converted into text using predefined output formats, customized formats, and scripts. To configure the output for extracted data, right-click any cell in the table and select Choose Data Extractor.

    The data editor context menu

    In this menu, you can select the output format (for example, as SQL INSERT statements, HTML table, or in CSV format) or a script that converts data into a specific format.

    Additionally, you can configure the following parameters:

    • Configure CSV Formats: Opens the CSV Formats dialog that you can use to manage your delimiter-separated values formats (for example, CSV or TSV).

    • Go To Scripts Directory: Opens a directory with the scripts that convert table data into various output formats.

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