Postgres Pro
Downloads
Home   >   mailing lists

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

From Surafel Temesgen
Subject Re: START/END line number for COPY FROM
Date
Msg-id CALAY4q--jqJxGV2Z-rBDRp9Ra_C7rsKHnPSSFRnO1z8eBgOw1A@mail.gmail.com
Whole thread Raw
In response to Re: START/END line number for COPY FROM  (David Rowley <david.rowley@2ndquadrant.com>)
Responses Re: START/END line number for COPY FROM  (Peter Eisentraut <peter.eisentraut@2ndquadrant.com>)
List pgsql-hackers
Tree view

Hi,
On Sat, Jan 5, 2019 at 1:10 PM David Rowley <david.rowley@2ndquadrant.com> wrote:
On Fri, 21 Dec 2018 at 02:02, Surafel Temesgen <surafel3000@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. 


it is not always the case to have in control of the data importing it may came from
external system

regards
Surafel

pgsql-hackers by date:

Previous
From: Surafel Temesgen
Date:
Subject: Re: FETCH FIRST clause PERCENT option
Next
From: Nikolay Shaplov
Date:
Subject: Re: [PATCH] check for ctags utility in make_ctags