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 ---------------------------(end of broadcast)---------------------------TIP 2: Don't 'kill -9' the postmaster
