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.