Re: pg_dump question (exclude schemas)

From: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
To: Jay Vee <jvsrvcs(at)gmail(dot)com>
Cc: pgsql-general General <pgsql-general(at)postgresql(dot)org>
Subject: Re: pg_dump question (exclude schemas)
Date: 2013-08-28 21:44:08
Message-ID: 521E6F28.8010003@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 08/28/2013 12:30 PM, Jay Vee wrote:
> I want to backup a database but exclude certain schemas with a patter.
>
> I have 100 schemas with the pattern: 'sch_000', 'sch_001', and so on.
>
> Will this work?
>
> $pg_dump <other_options> --exclude-schema='sch_*'
>
> this does not seem to exclude all schemas with this pattern ( 'sch_*'
> ), anything wrong here?

What version of Postgres?

What is the complete command line?

Does it exclude any of the schemas?

>
> thanks
>
>
> J.V.

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Luca Ferrari 2013-08-29 06:44:50 Re: pg_dump question (exclude schemas)
Previous Message Jay Vee 2013-08-28 19:30:29 pg_dump question (exclude schemas)