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

From Peter Eisentraut
Subject Re: START/END line number for COPY FROM
Date
Msg-id 6db582e8-2349-d322-aa36-fe654becbc31@2ndquadrant.com
Whole thread Raw
In response to START/END line number for COPY FROM  (Surafel Temesgen <surafel3000@gmail.com>)
Responses Re: START/END line number for COPY FROM  (Surafel Temesgen <surafel3000@gmail.com>)
List pgsql-hackers
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


pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Fast path for empty relids in check_outerjoin_delay()
Next
From: Tomas Vondra
Date:
Subject: Re: FETCH FIRST clause PERCENT option