Thread: 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