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

Gilles Darold <gilles@migops.com>

From: Gilles Darold <gilles@migops.com>
To: pgsql-hackers@lists.postgresql.org
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Cary Huang <cary.huang@highgo.ca>, Stéphane Tachoires <stephane.tachoires@gmail.com>
Date: 2023-03-11T18:51:01Z
Lists: pgsql-hackers

Attachments

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

Commits

Same data as JSON: GET /api/v1/messages/:b64id/commits the thread's linked commits as JSON, with link sources. API reference →
  1. Allow pg_dump to include/exclude child tables automatically.