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


Reply via email to