Re: START/END line number for COPY FROM - Mailing list pgsql-hackers

Surafel Temesgen <surafel3000@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