Re: Constraint not shown on \d ?

> 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