Peter Eisentraut <peter_e@gmx.net> writes:
> On fre, 2012-02-17 at 12:01 -0500, Tom Lane wrote:
>> lenka.piyush@gmail.com writes:
>>> when i restore a particular table using pg_restore (using option "-t") it
>>> doesn't restore my primary key...
>> This is not a bug. -t selects the table only, not associated indexes.
> But from a user's perspective, that behavior seems kind of useless.
Well, I can see the possible usefulness of a switch that says "give me
this table and all associated indexes/constraints" (other than FK
constraints, likely). But it would be something new, not -t.
regards, tom lane