Re: Restoring only a subset of schemas

Sylvain Cuaz <sylvain(at)ilm-informatique(dot)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