Re: [ADMIN] pg_dump and table exclusion: multiple patterns

2010-09-28 Thread Vibhor Kumar
On Sep 28, 2010, at 6:26 PM, Marc Mamin wrote: > But if I prefix my pattern with the schema name, then I finally get the > expected result: > >pg_dump -i -v -nXXX -T 'XXX.*2008*' -T ' XXX.*2009*' -T ' XXX.*201001*' -T > XXX.'*201002*' . > > > seems that the use of the -n flag require

Re: [ADMIN] pg_dump and table exclusion: multiple patterns

2010-09-28 Thread Vibhor Kumar
On Sep 28, 2010, at 6:26 PM, Marc Mamin wrote: > But if I prefix my pattern with the schema name, then I finally get the > expected result: > >pg_dump -i -v -nXXX -T 'XXX.*2008*' -T ' XXX.*2009*' -T ' XXX.*201001*' -T > XXX.'*201002*' . > > > seems that the use of the -n flag require

Re: [ADMIN] pg_dump and table exclusion: multiple patterns

2010-09-28 Thread Marc Mamin
here is a strange behaviour: I did first simplify my syntax with multiples -T flags: pg_dump -i -v -nXXX -T '*2008*' -T '*2009*' -T '*201001*' -T '*201002*' . still not working. But if I prefix my pattern with the schema name, then I finally get the expected result: pg_dump -i -