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