Re: pg_dump of partitioned table not working. - Mailing list pgsql-general

From Ron
Subject Re: pg_dump of partitioned table not working.
Date
Msg-id b0d87be4-c960-2c91-dafe-1d163063b818@gmail.com
Whole thread Raw
In response to Re: pg_dump of partitioned table not working.  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: pg_dump of partitioned table not working.
Re: pg_dump of partitioned table not working.
List pgsql-general
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.


-- 
Angular momentum makes the world go 'round.



pgsql-general by date:

Previous
From: Ron
Date:
Subject: Re: pg_dump of partitioned table not working.
Next
From: Adrian Klaver
Date:
Subject: Re: pg_dump of partitioned table not working.