Re: Howto define a constraint in a existing column - Mailing list pgsql-novice

Intengu Technologies wrote on 09.08.2009 11:23:
> 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
>
That should be

ALTER TABLE mytable
    ADD PRIMARY KEY (field13);

Or if you want to give the constraint a name:

ALTER TABLE mytable
    ADD CONSTRAINT pk_mytable PRIMARY KEY (field13);

Thomas