digoal
2023-03-15
PostgreSQL , PolarDB , pg_dump , --table-and-children , --exclude-table-and-children , --exclude-table-data-and-children
Allow pg_dump to include/exclude child tables automatically.
author Tom Lane <tgl@sss.pgh.pa.us>
Tue, 14 Mar 2023 20:09:03 +0000 (16:09 -0400)
committer Tom Lane <tgl@sss.pgh.pa.us>
Tue, 14 Mar 2023 20:09:03 +0000 (16:09 -0400)
commit a563c24c9574b74f4883c004c89275bba03c3c26
tree 0c868d94031103906136e74469e869cc63505f42 tree
parent 684ffac8c7d2647d919495727d469c73129202ea commit | diff
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