Re: START/END line number for COPY FROM

From: Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>
To: Surafel Temesgen <surafel3000(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: START/END line number for COPY FROM
Date: 2019-01-04 14:37:30
Message-ID: 6db582e8-2349-d322-aa36-fe654becbc31@2ndquadrant.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2019-01-04 14:57:59 Re: FETCH FIRST clause PERCENT option
Previous Message Adrian Klaver 2019-01-04 14:32:59 Re: Potentially undocumented behaviour change in Postgres 11 concerning OLD record in an after insert trigger