"Ian Harding" <[EMAIL PROTECTED]> writes: > The second is shorthand for the first. you get to choose the index name > in the first one.
IIRC you can force the index name in the second case too, by using the fully unabbreviated CONSTRAINT syntax: ..., CONSTRAINT indexname UNIQUE(colname), ... regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]