"Ian Harding" <iharding@tpchd.org> 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