Skip site navigation (1) Skip section navigation (2)

Re: Howto define a constraint in a existing column

From: Thomas Kellerer <spam_eater(at)gmx(dot)net>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Howto define a constraint in a existing column
Date: 2009-08-09 09:32:49
Message-ID: h5m540$oul$1@ger.gmane.org (view raw or flat)
Thread:
Lists: 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


In response to

Responses

pgsql-novice by date

Next:From: Intengu TechnologiesDate: 2009-08-09 10:15:15
Subject: Re: Howto define a constraint in a existing column
Previous:From: Intengu TechnologiesDate: 2009-08-09 09:23:50
Subject: Howto define a constraint in a existing column

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group