pg_restore --schema always returns an empty dump

Started by Nick Johnsonabout 20 years ago2 messagesgeneral
Jump to latest
#1Nick Johnson
arachnid@notdot.net

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

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Nick Johnson (#1)
Re: pg_restore --schema always returns an empty dump

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