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

From David G. Johnston
Subject Re: pg_dump of partitioned table not working.
Date
Msg-id CAKFQuwY5dkPtx9Q67dJfVTJuf+=E5TfGTbpQ2ej76OBm0gnCLg@mail.gmail.com
Whole thread Raw
In response to Re: pg_dump of partitioned table not working.  (Ron <ronljohnsonjr@gmail.com>)
Responses Re: pg_dump of partitioned table not working.  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
On Wed, Dec 2, 2020 at 5:14 PM Ron <ronljohnsonjr@gmail.com> wrote:

> 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.


I'd probably just relocate the table to a separate schema and require that all partitions are placed there as well.  Otherwise, the necessary information exists in the catalogs, so a solution is within reach (minor concern regarding concurrency).

David J.

pgsql-general by date:

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