Sylvain Cuaz <sylv...@ilm-informatique.fr> writes:
> Further, I don't see how it's an edge-case, at the core I just want to
> restore some but not all the
> schemas. This is possible for pg_dump, see my response to Adrian Klaver.
You have a very good point that it's annoying that pg_restore's
--schema switch doesn't act like pg_dump's --schema switch.
I could support changing that, but only if we also did something
about the fact that pg_restore's switch doesn't handle patterns.
The pattern aspect is kind of a mess, because pg_dump implements
that through a server-side regex, which is a facility pg_restore
doesn't have access to. Maybe it'd be good enough to implement
the "*" and "?" wildcards and stop there, but I'm not sure.
regards, tom lane
