Thursday, 29 August 2013

Remove uniqueness of index in PostgreSQL

Remove uniqueness of index in PostgreSQL

In my PosgreSQL DB I have a unique index created this way:
CREATE UNIQUE INDEX my_index ON my_table USING btree (my_column)
Is there way to alter the index to remove unique constraint? I looked
thorugh ALTER INDEX documentation but it doesn't seem to do what I need.
I know I can remove index and create another one. But I'd like to find a
better way if it exists.

No comments:

Post a Comment