SyntaxFix

[sql] Can I add a UNIQUE constraint to a PostgreSQL table, after it's already created?

psql's inline help:

\h ALTER TABLE

Also documented in the postgres docs (an excellent resource, plus easy to read, too).

ALTER TABLE tablename ADD CONSTRAINT constraintname UNIQUE (columns);

Examples related to sql

• Passing multiple values for same variable in stored procedure • SQL permissions for roles • Generic XSLT Search and Replace template • Access And/Or exclusions • Pyspark: Filter dataframe based on multiple conditions • Subtracting 1 day from a timestamp date • PYODBC--Data source name not found and no default driver specified • select rows in sql with latest date for each ID repeated multiple times • ALTER TABLE DROP COLUMN failed because one or more objects access this column • Create Local SQL Server database

Examples related to database

• Implement specialization in ER diagram • phpMyAdmin - Error > Incorrect format parameter? • Authentication plugin 'caching_sha2_password' cannot be loaded • Room - Schema export directory is not provided to the annotation processor so we cannot export the schema • SQL Query Where Date = Today Minus 7 Days • MySQL Error: : 'Access denied for user 'root'@'localhost' • SQL Server date format yyyymmdd • How to create a foreign key in phpmyadmin • WooCommerce: Finding the products in database • TypeError: tuple indices must be integers, not str

Examples related to postgresql

• Subtracting 1 day from a timestamp date • pgadmin4 : postgresql application server could not be contacted. • Psql could not connect to server: No such file or directory, 5432 error? • How to persist data in a dockerized postgres database using volumes • input file appears to be a text format dump. Please use psql • Postgres: check if array field contains value? • Add timestamp column with default NOW() for new rows only • Can't connect to Postgresql on port 5432 • How to insert current datetime in postgresql insert query • Connecting to Postgresql in a docker container from outside

Examples related to indexing

• numpy array TypeError: only integer scalar arrays can be converted to a scalar index • How to print a specific row of a pandas DataFrame? • What does 'index 0 is out of bounds for axis 0 with size 0' mean? • How does String.Index work in Swift • Pandas KeyError: value not in index • Update row values where certain condition is met in pandas • Pandas split DataFrame by column value • Rebuild all indexes in a Database • How are iloc and loc different? • pandas loc vs. iloc vs. at vs. iat?

Examples related to unique-constraint

• MySQL delete multiple rows in one query conditions unique to each row • Unique constraint violation during insert: why? (Oracle) • How to drop a unique constraint from table column? • How can I create a unique constraint on my column (SQL Server 2008 R2)? • MySQL - Make an existing Field Unique • Does MySQL ignore null values on unique constraints? • @UniqueConstraint annotation in Java • SQLite table constraint - unique on multiple columns • Can I add a UNIQUE constraint to a PostgreSQL table, after it's already created? • How do I specify unique constraint for multiple columns in MySQL?