Hello everyone, I'm building a postgresql db which will have to get lots of data from "the outside" (customers, that is). The db has lots of constraints, and I'm sure that our customers will offer lots of invalid information. We receive the information in csv format. My first thought was to read them into the database with COPY, but "COPY stops operation at the first error." What I need is an import where all valid lines from the csv files are read into the db, and I also get a logfile for all invalid lines, stating the line number plus the pg error message so I can see which constraint was violated. I can't think of a direct, elegant solution for this, does anyone have any suggestions? Thanks a lot! ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
