How to remove Unique in PostgreSQL?

Question

PostgreSQL

Created a table. Added "uniqueness" to one of the columns. Completed.
Then I wanted to remove unique from the column, but that was not the case. It gives me an error when running:


How to fix it?

Answer 1

ALTER TABLE "some_table" DROP CONSTRAINT "unique_somefield";

The constraint name can be obtained by query

SELECT *
FROM information_schema.constraint_table_usage
WHERE table_name = 'some_table';