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 0d61a3fe-abaf-edd4-60b5-ca54b1678105@2ndquadrant.com
Whole thread Raw
In response to Re: START/END line number for COPY FROM  (Surafel Temesgen <surafel3000@gmail.com>)
List pgsql-hackers
On 06/01/2019 12:59, Surafel Temesgen wrote:
> it is not always the case to have in control of the data importing it
> may came from
> external system

But the problem that David described remains:  If your data loading
requirement is so complicated that you need to load the file in chunks,
then doing it by line numbers will require you to skip over the leading
lines at every subsequent chunk.  That's not going to be good for larger
files.

I think your problem needs a different solution.

-- 
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: Using logical replication with older version subscribers
Next
From: Adrien NAYRAT
Date:
Subject: Re: [Proposal] Add accumulated statistics