Re: Easy dump of partitioned and inherited data

2023-05-18 Thread Przemysław Sztoch
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 empt

Easy dump of partitioned and inherited data

2023-05-17 Thread Przemysław Sztoch
|1. Switch --load-via-partition-root is very useful. Would it be a big deal to add extra information to the |||dump |custom format so that this switch can be specified from pg_restore level? 2. Another common usability problem is a quick dump of the selected parent table. It is important that