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