I know the -T command, but I'm trying to regex the "pattern" in -T in order to exclude all tables named program_1 onwards. I believe commonly you'd use -T "program_!0", but the ! negation keyword is not defined.
Thanks, Eudald El jue., 7 may. 2020 a las 19:36, Adrian Klaver (<adrian.kla...@aklaver.com>) escribió: > On 5/7/20 9:53 AM, Eudald Valcàrcel Lacasa wrote: > > Hello! > > I've been looking at the documentation and there seems to be no keyword > > for negation purposes. > > > > Am I missing something? Or it's like this? > > https://www.postgresql.org/docs/12/app-pgdump.html > > -T pattern > --exclude-table=pattern > > Do not dump any tables matching pattern. The pattern is interpreted > according to the same rules as for -t. -T can be given more than once to > exclude tables matching any of several patterns. > > When both -t and -T are given, the behavior is to dump just the > tables that match at least one -t switch but no -T switches. If -T > appears without -t, then tables matching -T are excluded from what is > otherwise a normal dump. > > > For what patterns you can use see: > > https://www.postgresql.org/docs/12/app-psql.html#APP-PSQL-PATTERNS > > > > > I'm trying to use pg_dump to create a database skeleton and I have > > tables like program_0, program_1, etc. And I'd like to dump all the > > tables but client_1 onwards. > > > > Does anybody happen to know a way to accomplish it? > > > > Thank you! > > Eudald > > > -- > Adrian Klaver > adrian.kla...@aklaver.com >
