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
>