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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
