Re: pg_dump of partitioned table not working.

On 12/2/20 6:14 PM, Ron wrote:
> On 12/2/20 5:50 PM, Tom Lane wrote:
>> I wrote:
>>> What you need here is something like "pg_dump -t measurement*"
>>> to indicate that you want measurement's child tables too, but
>>> AFAIR pg_dump has no such feature.  Maybe we should add it.
>> Or actually: that syntax does do something, but it selects
>> tables by pattern matching not hierarchy, ie you get everything
>> whose name starts with "measurement".  Depending on your naming
>> conventions, that might be close enough.
>>
>> It does seem like there might be reason to have a switch along
>> the lines of "--include-child-tables".
>
> That would be great, but won't help me in v12.

To clarify: I'm not being sarcastic.  Such a feature really would be useful.

--
Angular momentum makes the world go 'round.