Hubert (depesz) Lubaczewski • 3/29/2026

Waiting for PostgreSQL 19 – json format for COPY TO

This article covers the new JSON format option for the COPY TO command in PostgreSQL 19, committed by Andrew Dunstan on March 20, 2026. It allows exporting query results or table data as a stream of JSON objects (one per line, NDJSON style). The feature is currently limited to COPY TO (not COPY FROM) and is incompatible with options like HEADER, NULL, DELIMITER, and FORCE QUOTE. Column list support ensures only specified columns are included. The article also compares JSON output with normal and CSV formats, highlighting escaping differences.

0 comments

#json #postgresql #Copy To