October 25, 2023
Summary: in this tutorial, you will learn how to import data from files to PostgreSQL tables using DBeaver.
- Select one or more tables to which you want to import data. In the context menu, choose Import Data:
- In the window that appears, choose
CSV
and click Next.
- Select the input
CSV
file for each table you want to import. You can change the Importer settings (format specific) during this step:
- Set CSV-to-table mappings. You must set a column in the
CSV
file for each database table column. You can skip columns (the value will be set toNULL
in the target table column). You can set constant values for the table column if there is no source column in theCSV
.
- Set options for loading data in the database. These options may affect the loading’s performance:
Read our tutorial on Data Import and Replace to learn more about the replacing method option.
- 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:
- 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. In the end, you will see the following status message: