CSV 파일 Import 하기 [DBeaver]

[퍼옴]

Importing data from CSV format

You can import data from CSV file(s) directly into your database table(s).

1. Select a table(s) to which you want to import data. In the context menu choose "Import Data": 
2. Choose import format (CSV):

1. Select input CSV file for each table you want to import and you can change the Importer settings (format specific) at this step: 
2. Set CSV-to-table mappings. You need to set a column in the CSV file for each database table column. You can skip columns (the value will be set to NULL in the target table column). You can set constant values for the table column if there is no source column for it in the CSV. 
3. Set options for loading data in the database. These options may affect the loading's performance: 

About the replacing method option, you can read here.

1. Review which file(s) and to which table(s) you will import. You can also save all your settings as a task in this step: 
2. Press finish. See extraction progress. You can keep working with your database during the export process as the data loading will be performed in the background. Note: avoid changing data in tables you have selected to be imported while the import is in progress. In the end you will see the status message: 

Related topic: Migrating table(s) data to another database table(s)