pg_restore --schema always returns an empty dump

From: Nick Johnson <arachnid(at)notdot(dot)net>
To: PostgreSQL - General <pgsql-general(at)postgresql(dot)org>
Subject: pg_restore --schema always returns an empty dump
Date: 2006-04-12 20:53:17
Message-ID: 443D68BD.8000406@notdot.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message codeWarrior 2006-04-12 21:51:36 Re: Evaluating client processes vs stored procedures
Previous Message Tom Lane 2006-04-12 20:50:59 Re: "Hidden" field for each column