Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 08CE41335ED4 for ; Tue, 28 Sep 2010 10:36:11 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 20226-07 for ; Tue, 28 Sep 2010 13:36:04 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from mail-px0-f174.google.com (mail-px0-f174.google.com [209.85.212.174]) by mail.postgresql.org (Postfix) with ESMTP id 5B6521336FA7 for ; Tue, 28 Sep 2010 10:36:03 -0300 (ADT) Received: by pxi10 with SMTP id 10so1683612pxi.19 for ; Tue, 28 Sep 2010 06:36:03 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:subject:mime-version :content-type:from:in-reply-to:date:cc:content-transfer-encoding :message-id:references:to:x-mailer; bh=vp9VkvoPgsNMaIWg4SeJIzr8HdxEu9B/sSGrtvFQ/Zo=; b=of+yMuQMXQCaZb+TW6VX44XIrL+DwBMYeqMfAMSboItz9RKtAyxYbeJfpM7M2RtTvL WEjAKzor+DGWqoA+jZB4r4QFfpz0aUF6UA8LzL7cUtUhDXh2P0muWjK+dh6i/PScBQ7H 6SeDLrgW8piQwXMdmqsrw0lkDSDkLshr2vIng= 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=OrcR2ZYT1Wpc6cydlSYfoQFF+vivqa0eUF+Vsry7xhC5QmObvaz2oJRdOy4IEjTHc6 Tc2fcTyRgnnaj/5a0cQ54ShoNNZiMQ/Q20OPy/UfJPLk9QA2+GNWLjpYV0BofTS18t0B GSIDHt4HSuAVpb2ZXE+PEWk8fI319sHAmCcGM= Received: by 10.142.7.2 with SMTP id 2mr7814108wfg.77.1285680962891; Tue, 28 Sep 2010 06:36:02 -0700 (PDT) Received: from [192.168.23.141] ([121.241.184.130]) by mx.google.com with ESMTPS id i20sm8840945wff.17.2010.09.28.06.35.54 (version=TLSv1/SSLv3 cipher=RC4-MD5); Tue, 28 Sep 2010 06:35:56 -0700 (PDT) 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 In-Reply-To: Date: Tue, 28 Sep 2010 19:05:51 +0530 Cc: Content-Transfer-Encoding: quoted-printable Message-Id: <20A3FCB7-0F73-4B25-A812-8640741D7FEA@gmail.com> References: To: Marc Mamin X-Mailer: Apple Mail (2.1081) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201009/167 X-Sequence-Number: 35711 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