Horton

file_fdw: Support multi-line HEADER option.

Shinya Kato <shinya11.kato@gmail.com>

View thread View on postgr.es
From: Shinya Kato <shinya11.kato@gmail.com>
To: PostgreSQL-development <pgsql-hackers@postgresql.org>
Cc: Fujii Masao <masao.fujii@gmail.com>
Date: 2026-01-09T08:14:47Z
Lists: pgsql-hackers

Attachments

Hi hackers,
(CC: Fujii-san, committer of bc2f348e8)

Commit bc2f348e8[0] introduced multi-line HEADER support for COPY.
However, file_fdw does not yet support it, so I have implemented it in
the attached patch.

Since foreign table options in CREATE/ALTER FOREIGN TABLE are
specified as single-quoted strings, I updated defGetCopyHeaderOption()
to handle string values as well.

Thoughts?

[0] https://git.postgresql.org/gitweb/?p=postgresql.git;a=commit;h=bc2f348e87c02de63647dbe290d64ff088880dbe

--
Best regards,
Shinya Kato
NTT OSS Center

Commits

  1. file_fdw: Support multi-line HEADER option.

  2. Improve the error message in COPY with HEADER option.

  3. Support multi-line headers in COPY FROM command.