Re: pg_dump question (exclude schemas) - Mailing list pgsql-general

From Adrian Klaver
Subject Re: pg_dump question (exclude schemas)
Date
Msg-id 521E6F28.8010003@gmail.com
Whole thread Raw
In response to pg_dump question (exclude schemas)  (Jay Vee <jvsrvcs@gmail.com>)
List 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.klaver@gmail.com


pgsql-general by date:

Previous
From: Jay Vee
Date:
Subject: pg_dump question (exclude schemas)
Next
From: Luca Ferrari
Date:
Subject: Re: pg_dump question (exclude schemas)