>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 --exclude-schema='sch_*'
>this does not seem to exclude all schemas with this pattern ( 'sch_*' ),
>anything wrong here?
>t
On Wed, Aug 28, 2013 at 9:30 PM, Jay Vee wrote:
> $pg_dump --exclude-schema='sch_*'
>
> this does not seem to exclude all schemas with this pattern ( 'sch_*' ),
> anything wrong here?
The option is fine and works for me on 9.2.4, I suspect the could do a clash with the -N (exclude-schema).
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 --exclude-schema='sch_*'
this does not seem to exclude all schemas with this pattern
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 --exclude-schema='sch_*'
this does not seem to exclude all schemas with this pattern ( 'sch_*' ),
anything wrong here?
than
