Re: pg_dump of partitioned table not working.

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_dump of partitioned table not working.
Date: 2020-12-03 00:14:31
Message-ID: b0d87be4-c960-2c91-dafe-1d163063b818@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 12/2/20 5:50 PM, Tom Lane wrote:
> 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".

That would be great, but won't help me in v12.

--
Angular momentum makes the world go 'round.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-12-03 00:21:10 Re: pg_dump of partitioned table not working.
Previous Message Ron 2020-12-03 00:13:02 Re: pg_dump of partitioned table not working.