Bill Todd <pg@xxxxxxxxxx> writes: > I am trying to restore a table named contact in the contact schema. I > have tried two methods. The first is the command > pg_restore --dbname=app --format=custom --schema=contact > --table=contact.contact --username=postgres --single-transaction > contact.backup The correct incantation is --schema=contact --table=contact You can use the qualified-name syntax in pg_dump's --table switch, but nobody's gotten around to making pg_restore similarly bright. > pg_restore -L contact.list contact.backup > result.txt > This also runs without error but does not restore anything. Well, in that form it's not supposed to do anything except emit SQL into result.txt --- you probably want to use the -d switch, or else pipe the SQL into psql. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
