From: Vibhor Kumar <vibhor.aim@gmail.com>
To: Marc Mamin <M.Mamin@intershop.de>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_dump and table exclusion: multiple patterns
Date: Tue, 28 Sep 2010 18:50:10 +0530
Message-ID: <F9502EC8-9318-4F94-B1DE-C4199A2F1437@gmail.com> (raw)
In-Reply-To: <C4DAC901169B624F933534A26ED7DF31034BB800@JENMAIL01.ad.intershop.net>
References: <C4DAC901169B624F933534A26ED7DF31034BB7FD@JENMAIL01.ad.intershop.net>
<C4DAC901169B624F933534A26ED7DF31034BB800@JENMAIL01.ad.intershop.net>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: vibhor.aim@gmail.com, M.Mamin@intershop.de
Subject: Re: pg_dump and table exclusion: multiple patterns
In-Reply-To: <F9502EC8-9318-4F94-B1DE-C4199A2F1437@gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox