How do I ALTER a PostgreSQL table and make a column unique?

by

I figured it out from the PostgreSQL docs, the exact syntax is:

ALTER TABLE the_table ADD CONSTRAINT constraint_name UNIQUE (thecolumn);

Thanks Fred.

More Related Contents:

  1. How to delete duplicate entries?
  2. ERROR: there is no unique constraint matching given keys for referenced table “bar”
  3. Select rows which are not present in other table
  4. Optimize GROUP BY query to retrieve latest row per user
  5. How to implement a many-to-many relationship in PostgreSQL?
  6. Aggregate columns with additional (distinct) filters
  7. Check if value exists in Postgres array
  8. Insert data in 3 tables at a time using Postgres
  9. How to use ANY instead of IN in a WHERE clause?
  10. Is there a shortcut for SELECT * FROM?
  11. sql statement error: “column .. does not exist”
  12. Concatenate multiple result rows of one column into one, group by another column [duplicate]
  13. sql ORDER BY multiple values in specific order?
  14. Constraint defined DEFERRABLE INITIALLY IMMEDIATE is still DEFERRED?
  15. Simulate CREATE DATABASE IF NOT EXISTS for PostgreSQL?
  16. Sorting null values after all others, except special
  17. Reference alias in WHERE clause
  18. NOT NULL constraint over a set of columns
  19. ERROR: functions in index expression must be marked IMMUTABLE in Postgres
  20. Why postgres returns unordered data in select query, after updation of row?
  21. postgresql – sql – count of `true` values
  22. What is the difference between a LATERAL JOIN and a subquery in PostgreSQL?
  23. Creating temporary tables in SQL
  24. PostgreSQL where all in array
  25. PostgreSQL – fetch the rows which have the Max value for a column in each GROUP BY group
  26. Conditional SQL count
  27. How to get a list column names and datatypes of a table in PostgreSQL?
  28. Postgresql query between date ranges
  29. Why isn’t row level security enabled for Postgres views?
  30. Is there a postgres CLOSEST operator?

Leave a Comment