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
<https://commitfest.postgresql.org/43/2573/>".
--
Przemysław Sztoch | Mobile +48 509 99 00 66