You can only define the pri key on table creation. If you miss it there, you can only add a Unique index (which is pretty much 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 > ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
