Add support for COPY TO in tablesync for partitioned tables.

Ajin Cherian <itsajin@gmail.com>

From: Ajin Cherian <itsajin@gmail.com>

To: PostgreSQL mailing lists <pgsql-hackers@postgresql.org>

Date: 2025-11-11T03:08:52Z

Lists: pgsql-hackers

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →

Use "COPY table TO" for partitioned tables in initial table synchronization.
- 266543a62055 19 (unreleased) landed
Support COPY TO for partitioned tables.
- 4bea91f21f61 19 (unreleased) cited

Attachments

v1-0001-Support-for-COPY-TO-for-partitioned-tables-in-tab.patch (application/octet-stream) patch v1-0001

Hi all,

After patch [1] was committed, the COPY TO command is now supported
for partitioned tables. This change updates the tablesync logic to use
COPY TO for partitioned tables as well. This change will only be
invoked when the publication is configured with
publish_via_partition_root = true;
otherwise, partitioned tables will continue to be published using
their underlying partitions by default and publishing using partitions
already use COPY TO.

[1] - https://github.com/postgres/postgres/commit/4bea91f21f61d01bd40a4191a4a8c82d0959fffe

regards,
Ajin Cherian
Fujitsu Australia