> CREATE UNIQUE INDEX "activation_code_code_key" ON
> "public"."activation_code"
> USING btree ("code", "id_code_pool");
>
> or
>
> ALTER TABLE activation_code ADD UNIQUE ( code, id_code_pool );
>
> with \d command there is no difference but is different because the
> first command
> create an index deleteable with a "drop index".
Yes, you're right. Basically the only difference is that the latter
will make it a "constraint" that can only be dropped with DROP CONSTRAINT.
Also, if you wanted to create a unique non-btree index, partial index or
expressional index, you'd have to use the former syntax
Chris
