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

---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org

Reply via email to