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 →
-
Support multi-line headers in COPY FROM command.
- bc2f348e87c0 19 (unreleased) landed