"Jan C." <chaljan@gmail.com> writes:
> I have dump of an entire database and I'm trying to restore only one named
> table:
>> pg_restore --format=c -C -U myUser -d myDB /tmp/mydump -t my_table
> The command completes without errors/warnings but the resulting table in the
> database is missing the PKEY constraint !
Use pg_restore -l, then extract the lines relevant to your table, then
pg_restore -L to restore just the named items.
I think there's a TODO to make pg_restore's -t switch work more like
pg_dump's, but at the moment they're really quite different animals.
pg_restore doesn't have any logic about "oh, if he asked for this
item I bet he wants that one too".
regards, tom lane