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

From Tom Lane
Subject Re: pg_dump of partitioned table not working.
Date
Msg-id 1681291.1606953006@sss.pgh.pa.us
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.
List pgsql-general
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".

            regards, tom lane



pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: pg_dump of partitioned table not working.
Next
From: Martin Goodson
Date:
Subject: Re: "Server versions prior to 8.0 do not support savepoints" when using JDBC ...