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 ade1b65f-211b-ba4f-468a-c00df93c6f1a@gmail.com
Whole thread Raw
In response to Re: pg_dump of partitioned table not working.  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
On 12/2/20 5:49 PM, David G. Johnston wrote:
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. 

Not only adhering to a naming scheme, but ensuring that there aren't any other tables which match "measurement*".

--
Angular momentum makes the world go 'round.

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: pg_dump of partitioned table not working.
Next
From: Ron
Date:
Subject: Re: pg_dump of partitioned table not working.