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
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
