pgsql: Allow pg_dump to include/exclude child tables automatically.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Allow pg_dump to include/exclude child tables automatically.
Date: 2023-03-14 20:09:15
Message-ID: E1pcAxO-003YLG-Gv@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Allow pg_dump to include/exclude child tables automatically.

This patch adds new pg_dump switches
--table-and-children=pattern
--exclude-table-and-children=pattern
--exclude-table-data-and-children=pattern
which act the same as the existing --table, --exclude-table, and
--exclude-table-data switches, except that any partitions or
inheritance child tables of the table(s) matching the pattern
are also included or excluded.

Gilles Darold, reviewed by Stéphane Tachoires

Discussion: https://postgr.es/m/5aa393b5-5f67-8447-b83e-544516990ee2@migops.com

Branch
------
master

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

Modified Files
--------------
doc/src/sgml/ref/pg_dump.sgml | 42 ++-
src/bin/pg_dump/pg_dump.c | 86 ++++++-
src/bin/pg_dump/t/002_pg_dump.pl | 539 +++++++++++++++++++++++++++++++++------
3 files changed, 571 insertions(+), 96 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2023-03-14 23:17:46 pgsql: Fix corner case bug in numeric to_char() some more.
Previous Message Tom Lane 2023-03-14 15:10:52 pgsql: Remove unnecessary code in dependency_is_compatible_expression()