On 20/12/2018 14:02, Surafel Temesgen 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.
It seems a bit fragile to me if I want to skip a footer and need to figure out the total line count, subtract one, and then oh, was it zero- or one-based. -- Peter Eisentraut http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services