On Sun, Mar 12, 2023 at 03:46:52PM -0400, Tom Lane wrote: > What I propose we do about that is further tweak things so that > load-via-partition-root forces dumping via COPY. AFAIK the only > compelling use-case for dump-as-INSERTs is in transferring data > to a non-Postgres database, which is a context in which dumping > partitioned tables as such is pretty hopeless anyway. (I wonder if > we should have some way to dump all the contents of a partitioned > table as if it were unpartitioned, to support such migration.)
I think that what this other thread is about. https://commitfest.postgresql.org/42/4130/ pg_dump all child tables with the root table