DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=subject:mime-version:content-type:from:in-reply-to:date:cc
	:content-transfer-encoding:message-id:references:to:x-mailer;
	b=b4g3eaq27NB3d0W9XyS3gVuP9kjuE5+c5+lgL3yHtthjJW+C7pngaxGtI1kBrrnYtE
	YwUHG1MogolAAK8lQa0AtJdEkmEAJizJCIC3p2MyfcGqPoH/EO2BX5YVziIJHtly/Ej5
	KFCpWZQXO29PcKJJOxbxMWJxbuOlSC9TpSvGc=
Subject: Re: pg_dump and table exclusion: multiple patterns
Mime-Version: 1.0 (Apple Message framework v1081)
Content-Type: text/plain; charset=us-ascii
From: Vibhor Kumar <vibhor.aim@gmail.com>
In-Reply-To: 
 <C4DAC901169B624F933534A26ED7DF31034BB800@JENMAIL01.ad.intershop.net>
Date: Tue, 28 Sep 2010 18:50:10 +0530
Cc: <pgsql-admin@postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <F9502EC8-9318-4F94-B1DE-C4199A2F1437@gmail.com>
References: 
 <C4DAC901169B624F933534A26ED7DF31034BB7FD@JENMAIL01.ad.intershop.net>
	<C4DAC901169B624F933534A26ED7DF31034BB800@JENMAIL01.ad.intershop.net>
To: Marc Mamin <M.Mamin@intershop.de>


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:
>=20
>    pg_dump -i -v -nXXX -T 'XXX.*2008*' -T ' XXX.*2009*' -T ' =
XXX.*201001*' -T XXX.'*201002*' .....
>=20
>=20
> 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=20

pg_dump -i -v -n XXXX -T '*.2008*' ....

Thanks & Regards,
Vibhor Kumar (PCP & OCP)
ITIL V3 Cerftified.
Web:www.EnterpriseDB.com