]> git.ipfire.org Git - thirdparty/postgresql.git/commit
COPY TO FORMAT JSON: respect column list order
authorAndrew Dunstan <andrew@dunslane.net>
Sat, 27 Jun 2026 20:48:35 +0000 (16:48 -0400)
committerAndrew Dunstan <andrew@dunslane.net>
Sat, 27 Jun 2026 21:50:45 +0000 (17:50 -0400)
commiteffb923d9dec8fd4a5102fee80e52d65d86747c8
tree1231ec4904428aabdef1807ccfa7595ff7fef9bc
parenta40fdf658862b3221a35268f8c74abfd46b9e93c
COPY TO FORMAT JSON: respect column list order

When COPY TO with FORMAT json is given an explicit column list that
names all columns in a different order, the JSON output incorrectly
used the table's physical column order instead of the requested order.

This happened because BeginCopyTo() only built a restricted TupleDesc
when list_length(attnumlist) < tupDesc->natts.  When all columns are
listed (just reordered), this condition was false and no projected
TupleDesc was built, causing CopyToJsonOneRow() to emit columns in
physical order.

Fix by also building the projected TupleDesc when an explicit column
list was provided (attnamelist != NIL), even if it names all columns.

Author: Baji Shaik <baji.pgdev@gmail.com>
Reviewed-by: Andrew Dunstan <andrew@dunslane.net>
Discussion: https://postgr.es/m/CA+fm-ROd4cNKM524n6EdgtZ9xOzOHJDNv8J_9Mvr2+2t1qWSDw@mail.gmail.com
src/backend/commands/copyto.c
src/test/regress/expected/copy.out
src/test/regress/sql/copy.sql