PostgreSQL – Rename Constraint

Below is the syntax to rename a constraint in Postgres database where table_name is the name of the table and old_constraint_name is the current name of the constraint to be renamed and new_constraint_name is the new name for the constraint.

ALTER TABLE table_name RENAME CONSTRAINT old_constraint_name TO new_constraint_name;

See also  PostgreSQL - LIKE operator