Postgres Pro
Downloads
Home   >   mailing lists

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

From Jay Vee
Subject pg_dump question (exclude schemas)
Date
Msg-id CADq_mb985cqVpqKPcag7j62dsnCzwmcz-FA-GKjP06G2LEGYXg@mail.gmail.com
Whole thread Raw
Responses Re: pg_dump question (exclude schemas)  (Adrian Klaver <adrian.klaver@gmail.com>)
Re: pg_dump question (exclude schemas)  (Luca Ferrari <fluca1978@infinito.it>)
Re: pg_dump question (exclude schemas)  (vinayak <vinpokale@gmail.com>)
List pgsql-general
Tree view
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?

thanks


J.V.

pgsql-general by date:

Previous
From: Filip Rembiałkowski
Date:
Subject: 9.0 hot standby, consistent recovery state question
Next
From: Adrian Klaver
Date:
Subject: Re: pg_dump question (exclude schemas)