Re: [Proposal] Allow pg_dump to include all child tables with the root table

From: Gilles Darold <gilles(at)migops(dot)com>
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Cary Huang <cary(dot)huang(at)highgo(dot)ca>, Stéphane Tachoires <stephane(dot)tachoires(at)gmail(dot)com>
Subject: Re: [Proposal] Allow pg_dump to include all child tables with the root table
Date: 2023-03-12 09:04:34
Message-ID: 41fcdf91-9b07-2944-496f-de4d9eb49835@migops.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Le 11/03/2023 à 19:51, Gilles Darold a écrit :
> Le 04/03/2023 à 20:18, Tom Lane a écrit :
>> As noted, "childs" is bad English and "partitions" is flat out wrong
>> (unless you change it to recurse only to partitions, which doesn't
>> seem like a better definition).  We could go with
>> --[exclude-]table-and-children, or maybe
>> --[exclude-]table-and-child-tables, but those are getting into
>> carpal-tunnel-syndrome-inducing territory 🙁.  I lack a better
>> naming suggestion offhand.
>
>
> In attachment is version 3 of the patch, it includes the use of
> options suggested by Stephane and Tom:
>
>     --table-and-children,
>
>     --exclude-table-and-children
>
>     --exclude-table-data-and-children.
>
>  Documentation have been updated too.
>
>
> Thanks
>

New version v4 of the patch attached with a typo in documentation fixed.

--
Gilles Darold.

Attachment Content-Type Size
0001-dump-with-child-v4.patch text/x-patch 46.9 KB

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2023-03-12 10:07:33 Re: Add LZ4 compression in pg_dump
Previous Message Ankit Kumar Pandey 2023-03-12 08:17:50 Re: [PoC] Implementation of distinct in Window Aggregates