On Fri, 21 Dec 2018 at 02:02, Surafel Temesgen <surafel3...@gmail.com> wrote: > 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'm struggling a bit to see the sense in this. If you really want to improve the performance of a long copy, then I think it makes more sense to have performed the backup in multiple pieces in the first place. Having the database read the input stream and ignore the first N lines sounds like a bit of a waste of effort, and effort that wouldn't be required if the COPY TO had been done in multiple pieces. -- David Rowley http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
