On Thu, 13 Aug 2026 at 21:12, Mariyan Clement S <[email protected]> wrote: > > Hi PostgreSQL community, > > I have been testing the new integer form of the COPY FROM HEADER option in > PostgreSQL 19 Beta 2 and wanted to share an edge-case observation for > confirmation. > > I tested a CSV file containing only 5 lines: > > 3 metadata lines
So, it's not really a CSV file, or at least not compliant with the relevant RFC 4180? > Could someone please confirm whether this is the expected/intended behavior > for HEADER ? The docs are clear: "HEADER [...] On input, [i]f set to a non-negative integer, that number of lines are discarded." Unless you suggest we raise an error when the input file doesn't contain at least as many lines as indicated by the user's integer input to HEADER, the behaviour of ignoring lines indicated by the user to be headers is fully expected. Kind regards, Matthias van de Meent Databricks (https://www.databricks.com)
