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;