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.