Re: pg_dump and table exclusion: multiple patterns

From: Vibhor Kumar <vibhor(dot)aim(at)gmail(dot)com>
To: Marc Mamin <M(dot)Mamin(at)intershop(dot)de>
Cc: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: pg_dump and table exclusion: multiple patterns
Date: 2010-09-28 13:20:10
Message-ID: F9502EC8-9318-4F94-B1DE-C4199A2F1437@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message osman mohamad 2010-09-28 13:31:03 question about phppgadmin
Previous Message Marc Mamin 2010-09-28 12:56:03 Re: pg_dump and table exclusion: multiple patterns