Re: Easy dump of partitioned and inherited data - Mailing list pgsql-hackers

Przemysław Sztoch wrote on 17.05.2023 17:46:

2. Another common usability problem is a quick dump of the selected parent table.
It is important that it should includes all inherited tables or subpartitions.
Now you can't just specify -t root-table-name, because you'll usually get an empty data dump.

The list of necessary tables is sometimes very long and, when using timescaledb, partition tables are called not humanly.


Just saw that the problem was solved in "[Proposal] Allow pg_dump to include all child tables with the root table"
and "pg_dump - read data for some options from external file".