Surafel Temesgen <surafel3...@gmail.com> writes: > Currently we can skip header line on COPY FROM but having the ability to > skip and stop copying at any line can use to divide long copy operation and > enable to copy a subset of the file and skipping footer. Attach is a patch > for it
I do not think this is a good idea. We have resisted attempts to add ETL-like features to COPY on the grounds that it would add complexity and cost performance, and that that's not what COPY is for. This seems to fall squarely in the domain of something you should be doing with another tool. regards, tom lane