SELECT * FROM pg_constraint WHERE conname = '<ConstraintName>';
SELECT * FROM <TableName> WHERE <UniqueColumn> = '<ValueThatCausedViolation>';
SELECT * FROM <ReferencedTableName> WHERE <ReferencedColumn> = '<ValueThatCausedViolation>';
\d <TableName>
ALTER TABLE <TableName> DROP CONSTRAINT <ConstraintName>;
ALTER TABLE <TableName> ADD CONSTRAINT <ConstraintName> UNIQUE (<ColumnName>);
(Perfect for DevOps & SREs)
(Perfect for DevOps & SREs)