pgsql: pg_dump: Allow pg_dump to dump the statistics for foreign tables

From: Fujii Masao <fujii(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: pg_dump: Allow pg_dump to dump the statistics for foreign tables
Date: 2025-06-18 05:57:25
Message-ID: [email protected]
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

pg_dump: Allow pg_dump to dump the statistics for foreign tables.

Commit 1fd1bd87101 introduced support for dumping statistics with
pg_dump and pg_dumpall, covering tables, materialized views, and indexes.
However, it overlooked foreign tables, even though functions like
pg_restore_relation_stats() support them.

This commit fixes that oversight by allowing pg_dump and pg_dumpall
to include statistics for foreign tables.

Author: Fujii Masao <masao(dot)fujii(at)gmail(dot)com>
Reviewed-by: Corey Huinker <corey(dot)huinker(at)gmail(dot)com>
Reviewed-by: Nathan Bossart <nathandbossart(at)gmail(dot)com>
Discussion: https://postgr.es/m/[email protected]

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/c2e2589ab969eb802493191c79de844bf7dc3a6e

Modified Files
--------------
doc/src/sgml/ref/pg_dump.sgml | 7 ++++---
doc/src/sgml/ref/pg_dumpall.sgml | 3 ++-
src/bin/pg_dump/pg_dump.c | 4 +++-
3 files changed, 9 insertions(+), 5 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Bruce Momjian 2025-06-18 20:43:52 pgsql: doc config.sgml: use "-" and not "_" for varlistentry "id"s
Previous Message Michael Paquier 2025-06-18 02:11:48 pgsql: Document "relrewrite" at the top of heap_create_with_catalog()