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 CAKFQuwZOYU3mDcFGp4QhQixjRV38Jv3_mP7908KZO3-zYPOxKg@mail.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.  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
On Wednesday, December 2, 2020, Tom Lane <tgl@sss.pgh.pa.us> 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.

 -t accepts a pattern in pg_dump.  But that requires the user to adhere to a naming scheme.  There is room for a long-form argument in a similar vein to
--load-via-partition-root
to export through partition root.

David J.

pgsql-general by date:

Previous
From: Dave Cramer
Date:
Subject: Re: "Server versions prior to 8.0 do not support savepoints" when using JDBC ...
Next
From: Tom Lane
Date:
Subject: Re: pg_dump of partitioned table not working.