Horton

Add HEADER support to COPY text format

Peter Eisentraut <peter@eisentraut.org>

View on postgr.es
Commit: 43f33dc018a4b77ced78a0a6df8ed5d450cfe5f4
Author: Peter Eisentraut <peter@eisentraut.org>
Date: 2022-01-28T08:44:47Z
Releases: 15.0 
Add HEADER support to COPY text format

The COPY CSV format supports the HEADER option to output a header
line.  This patch adds the same option to the default text format.  On
input, the HEADER option causes the first line to be skipped, same as
with CSV.

Author: Rémi Lapeyre <remi.lapeyre@lenstra.fr>
Discussion: https://www.postgresql.org/message-id/flat/CAF1-J-0PtCWMeLtswwGV2M70U26n4g33gpe1rcKQqe6wVQDrFA@mail.gmail.com

Files

PathChange+/−
contrib/file_fdw/expected/file_fdw.out modified +1 −3
contrib/file_fdw/sql/file_fdw.sql modified +0 −1
doc/src/sgml/ref/copy.sgml modified +1 −1
src/backend/commands/copy.c modified +2 −2
src/backend/commands/copyto.c modified +4 −1
src/include/commands/copy.h modified +1 −1
src/test/regress/expected/copy.out modified +8 −0
src/test/regress/sql/copy.sql modified +12 −0

Documentation touched

Discussion