* Dave Held ([EMAIL PROTECTED]) wrote: > A possibility that I would like to pursue is to keep the staging data > from the previous day, do a COPY TO, import the new data into > another staging table with a COPY FROM, then export the fresh > data with another COPY TO. Then, I can write a fast C/C++ > program to do a line-by-line comparison of each record, isolating > the ones that have changed from the previous day. I can then > emit those records in a change file that should be relatively small > and easy to update. Of course, this scheme can only work if > COPY TO emits the records in a reliable order.
sort -u old new > changes
?
Stephen
signature.asc
Description: Digital signature
