On Thu, 24 Feb 2011, Brian Kurle wrote:
> For one of my tables, after performing a pg_dump, I see the following:
>
> ALTER TABLE ONLY action
> ADD CONSTRAINT action_pkey PRIMARY KEY (transactionid);
>
> You would do something similar.
Brian,
Thanks very much for clarifying the syntax. While I read the doc page I
did not have all necessary parts in the one statement. Now I understand how
to add a new primary key.
Rich