Re: How to create primary key - Mailing list pgsql-general

Reg Me Please wrote:
> What'd be the syntax to create a primary key on an already 
> build table?

As described in the documentation:

ALTER TABLE <name> ADD [CONSTRAINT <constraint name>]
PRIMARY KEY (<colname> [, ...])
[WITH (FILLFACTOR = <number>)] [USING INDEX TABLESPACE <tbsp name>]

Yours,
Laurenz Albe