Copy does work really well, that's actually where I've began again. Scrapped what I had. My method currently is taking all my raw data (folder of CSVs) and doin

Copy does work really well, that's actually where I've began again. Scrapped what I had. My method currently is taking all my raw data (folder of CSVs) and doing the following. 1. Create psql tables exactly how there are in the CSVs. 2. COPY all the data into each corresponding table. 3. Create NEW database/tables with the schema I want (only including the columns needed and proper names). I'm thinking this is where your materialized view comes in to play. 4. Magic?