SQL

postgresql resolv duplicate value violates unique constraint

SELECT setval(pg_get_serial_sequence('users', 'id'), coalesce(max(id)+1, 1), false) FROM users;

postgres duplicate key value violates unique constraint already exists

SELECT setval('the_primary_key_sequence', (SELECT MAX(the_primary_key) FROM the_table)+1);

duplicate key value violates unique constraint in postgresql

SELECT setval('tableName_id_seq', max(id)) FROM gst_codes;