I am tying to define a primary key constraint to an existing table,
this is what I have tried so far
ALTER TABLE mytable ALTER COLUMN field13 CONSTRAINT name PRIMARY KEY;
I get the following error: ERROR: syntax error at or near "CONSTRAINT"
SQL state: 42601
Character: 61
--
Sindile Bidla