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-11 18:51:01
Message-ID: cabfb167-b953-fb2b-33df-0f9db2394005@migops.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

--
Gilles Darold

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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Justin Pryzby 2023-03-11 19:16:19 Re: Option to not use ringbuffer in VACUUM, using it in failsafe mode
Previous Message Mark Dilger 2023-03-11 18:08:32 Re: Transparent column encryption