Want to import multiple CSV files into a single PostgreSQL table?
Using Withdata software FileToDB, a CSV importer for PostgreSQL, you can import multiple CSV files into a single PostgreSQL table in one go. Easily and fast.
- Can run in GUI mode, Step by Step, just a few mouse clicks.
- Can run in Command line, for Scheduled Tasks and Streams.
- Convert locally, Avoid uploading LARGE CSV file(s) to online services.
- Support Windows, Linux, macOS.
Import multiple CSV files into a single PostgreSQL table
Login to PostgreSQL -> Choose CSV files -> Set PostgreSQL table -> Import CSV files to PostgreSQL table
Choose PostgreSQL and logon.
Click “Wizard – N Files To 1 Table” at task dialog.
Select the “CSV” file type.
then show the wizard.
1. Select a folder that constains CSV files.
Support large CSV files ( > 4GB ).
2. Config first CSV file importing options.
3. Select a PostgreSQL table and config fields.
4. Preview data will be in PostgreSQL table.
5. Import multiple CSV files to the PostgreSQL table.
View imported data in PostgreSQL table
You can schedule and automate this converting task by:
1) Save session and create .bat (Windows) or .sh (Linux/macOS)