Обсуждение: pg_restore --schema always returns an empty dump

If I create a complete database dump in custom or tar format, with a
command like the following:
pg_dump -Fc dbname > db.dump

using "pg_restore db.dump", as expected, returns the entire dump.
However, "pg_restore --schema foo db.dump", where 'foo' is the name of a
schema present in the database dump always returns an empty dump.
"pg_restore --schema foo --table bar" returns the table foo.bar, though.

Does anyone know why this is?

-Nick

Nick Johnson <arachnid@notdot.net> writes:
> using "pg_restore db.dump", as expected, returns the entire dump.
> However, "pg_restore --schema foo db.dump", where 'foo' is the name of a
> schema present in the database dump always returns an empty dump.
> "pg_restore --schema foo --table bar" returns the table foo.bar, though.

> Does anyone know why this is?

Probably because it's broken :-(.  I've applied a patch.

            regards, tom lane