Importing non formatted CSV into a Postgres Database

Question

I am trying to import a csv into postgres.

I have my tables set up and my csv file is formatted in a way such that it is clear where the data I need is, but it is not formatted in the same way as the tables.

For a simple example: I have

Table1 with field1 field2 and field3

Table2 with field1 and field2

my csv has value1,value2,value3,value4

I want to load value1 into Table1 field2, value2 into Table2 field1, and value3 into Table1 field3.

I was wondering if there exists any tool, within postgres or without for handling the mapping and import, or is this something I would need to write a separate script or program for. If the second, any suggestions would be welcome.

Thank you very much!

Answer 1

Create a temporary table with the same structure as your CSV, load the CSV data into this table, and then insert data into table1 and table2 from the temporary table.