Skip site navigation (1) Skip section navigation (2)

Re: Changing the Primary Key Column

From: Rich Shepard <rshepard(at)appl-ecosys(dot)com>
To: pdxpug(at)postgresql(dot)org
Subject: Re: Changing the Primary Key Column
Date: 2011-02-24 16:58:31
Message-ID: alpine.LNX.2.00.1102240856490.4006@salmo.appl-ecosys.com (view raw or flat)
Thread:
Lists: pdxpug
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

In response to

Responses

pdxpug by date

Next:From: Michael EwanDate: 2011-02-24 17:41:19
Subject: Re: Changing the Primary Key Column
Previous:From: Brian KurleDate: 2011-02-24 16:33:35
Subject: Re: Changing the Primary Key Column

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group