Re: START/END line number for COPY FROM

From: Surafel Temesgen <surafel3000(at)gmail(dot)com>
To: David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: START/END line number for COPY FROM
Date: 2019-01-06 11:59:05
Message-ID: CALAY4q--jqJxGV2Z-rBDRp9Ra_C7rsKHnPSSFRnO1z8eBgOw1A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi,
On Sat, Jan 5, 2019 at 1:10 PM David Rowley <david(dot)rowley(at)2ndquadrant(dot)com>
wrote:

> On Fri, 21 Dec 2018 at 02:02, Surafel Temesgen <surafel3000(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Nikolay Shaplov 2019-01-06 12:42:20 Re: [PATCH] check for ctags utility in make_ctags
Previous Message Surafel Temesgen 2019-01-06 11:40:29 Re: FETCH FIRST clause PERCENT option