Re: Cannot restore table using pg_restore

Bill Todd <pg(at)dbginc(dot)com> 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