Re: Adding a primary key - Mailing list pgsql-general

From Thalis A. Kalfigopoulos
Subject Re: Adding a primary key
Date
Msg-id Pine.LNX.4.21.0106121656510.19889-100000@aluminum.cs.pitt.edu
Whole thread Raw
In response to Adding a primary key  ("P. Dwayne Miller" <dmiller@espgroup.net>)
Responses Re: Adding a primary key  (GH <grasshacker@over-yonder.net>)
List pgsql-general
You can only define the pri key on table creation. If you miss it there, you can only add a Unique index (which is
prettymuch the same I think) 

Check http://www.postgresql.org/idocs/index.php?sql-altertable.html


cheers,
thalis

On Tue, 12 Jun 2001, P. Dwayne Miller wrote:

> How do I add a primary key to a table.  The database was migrated using
> pgAdmin and no indexes or keys were migrated.  I'd like to add a primary
> key constraint to a table.
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl
>


pgsql-general by date:

Previous
From: Stephan Szabo
Date:
Subject: Re: abs() does not exists..
Next
From: Martín Marqués
Date:
Subject: Re: Permissions & Ownership (BUG?)