I have some php code that will be pulling in a file via ftp. This file will contain 20,000+ records that I then need to pump into the postgres db. These records will represent a subset of the records in a certain table. I basically need an efficient way to pump these rows into the table, replacing matching rows (based on id) already there and inserting ones that aren't. Sort of looping through the result and inserting or updating based on the presents of the row, what is the best way to handle this? This is something that will run nightly.
