CLion
 
2021.2
Shortcuts: Windows
Get CLion
You are viewing the documentation for an earlier version of CLion.
  1. Language and framework-specific guidelines
  2. Database tools and SQL
  3. Export and import data
  4. Import

Import

Last modified: 29 September 2021

To import data from a script file, run the file as it is described in Run database code. In addition to script files, you can import a CSV, TSV, or any other text file that contains delimiter-separated values.

Import data to a database

  1. In the Database tool window (View | Tool Windows | Database), right-click a data source.

  2. Select Run SQL Script.

  3. In the Select Path window, navigate to the SQL file that you want to apply.

    Run an SQL file

tip

To see other options of how you can run an SQL file against a database, see Run database code.

Import delimiter-separated values into a database

  1. In the Database tool window (View | Tool Windows | Database), right-click a schema or a table and select Import Data from File.

  2. Navigate to the file that contains delimiter-separated values and double-click it.

  3. In the Import {0} File dialog, specify the data conversion settings and click Import.

    To mark the first row as a header, right-click the row in the Data Preview pane and select First Row Is Header.

    Import delimiter-separated values into a database

note

If you drag a file into a schema or carry out the Import from File command for a schema, CLion creates a new table for the data that you import. If you perform the same actions for an existing table, CLion adds the data to that table.

Restore a full data dump for MySQL and PostgreSQL

You can restore data dumps by means of the mysql client utility for MySQL, or pg_restore or psql for PostgreSQL. The pg_restore option is used for custom-format pg_dump -Fc or directory-format pg_dump -Fd dumps. The psql option is used for SQL-format dumps.

If you see no restore options in the context menu, verify that you use a correct JDBC URL for the data source.

tip

For PostgreSQL, you can use Restore with "pg_restore" on a table level.