> > I think an easy approach would be to COPY the CSV files into a separate > database using psql's \copy command and then pg_dump that as separate insert > statements with pg_dump —inserts. >
This was my first thought too. However, as I understand, pg_dump --insert basically runs INSERT INTO ... sql for every row. In other words, each row is un-prepared and executed individually. That is also not real life scenario.
