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 requires to use these schema names within the patterns ...
By default tablename without namespace get search in Public Schema.
Please try something like this
pg_dump -i -v -n XXXX -T '*.2008*' ....
Thanks & Regards,
Vibhor Kumar (PCP & OCP)
ITIL V3 Cerftified.
Web:www.EnterpriseDB.com