Re: pg_dump negation regex

2020-05-07 Thread Eudald Valcàrcel Lacasa
You're right Rob. Thanks, it worked! Eudald El jue., 7 may. 2020 a las 21:16, Rob Sargent () escribió: > > > > On May 7, 2020, at 1:03 PM, Eudald Valcàrcel Lacasa < > eudald.valcar...@gmail.com> wrote: > > > > I know the -T command, but I'm trying to regex the "pattern" in -T in > order to exclu

Re: pg_dump negation regex

2020-05-07 Thread Rob Sargent
> On May 7, 2020, at 1:03 PM, Eudald Valcàrcel Lacasa > wrote: > > 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. > > T

Re: pg_dump negation regex

2020-05-07 Thread Eudald Valcàrcel Lacasa
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 () escribió: > On 5/7

Re: pg_dump negation regex

2020-05-07 Thread Adrian Klaver
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 no

pg_dump negation regex

2020-05-07 Thread Eudald Valcàrcel Lacasa
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? 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