I am new to database management and we are using PostgreSQL. All I need to do is to migrate CSV files (corresponding to around 200 tables) to our database. Manually creating tables for every CSVfile is a bit tiresome, so please help me out. Is there any way not only to import data, but also to generate tables from CSV files?
Postgresql – How to create and populate a PostgreSQL table from CSV automatically
csvmigrationpostgresql
Related Question
- Postgresql – Behavior of PostgreSQL COPY FROM
- PostgreSQL – How to Prevent Sequence Advancement on COPY Failures
- Repopulating Oracle tables using data from Excel/CSV file
- Postgresql – Importing CSV into multiple tables using PostgreSQL
- Postgresql – Best DB structure for large CSVs
- SQL Server – Bulk Table Creation and Data Import
Best Answer
You might look at PgFutter to help you out. It sounds like it would fit your use case well, because it creates tables for CSV formatted data based on the header line, and then loads the data into the tables.