Sylvain Cuaz <sylvain@xxxxxxxxxxxxxxxxxxx> 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
