Re: Extend COPY FROM with HEADER <integer> to skip multiple lines

Dagfinn Ilmari Mannsåker <ilmari@ilmari.org>

From: Dagfinn Ilmari Mannsåker <ilmari@ilmari.org>
To: Shinya Kato <shinya11.kato@gmail.com>
Cc: Andrew Dunstan <andrew@dunslane.net>, Fujii Masao <masao.fujii@oss.nttdata.com>, pgsql-hackers@postgresql.org
Date: 2025-06-11T10:21:56Z
Lists: pgsql-hackers
Shinya Kato <shinya11.kato@gmail.com> writes:

> On Tue, Jun 10, 2025 at 7:05 PM Dagfinn Ilmari Mannsåker <ilmari@ilmari.org>
> wrote:
>
>> Although not useful for the above format, and not intended to derail or
>> bloat the proposal in this thread, would it be useful to have a mode
>> that combines skip and match?  I.e. skip N lines, then check the fields
>> in the one after that against the target columns.
>
> I think it would be useful, but the target columns are not always at the
> bottom of the header. For example, the target columns could be on the first
> line, with explanations or sub-columns on the lines that follow.
>
> Considering this, the patch would become too complicated, so I'd like to
> keep this out of scope. What do you think?

Yeah, that's a valid point, and as I said I don't want to bloat or
derail this proposal, so keeping it simple is fine.

- ilmari



Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →
  1. Support multi-line headers in COPY FROM command.