UPDATE
ID SEQUENCE
TO HIGHEST

Updating a PostgreSQL ID sequence to match the highest value — a tiny step, but one that’s worth keeping in my backend notes.

Steps

SELECT MAX(id) FROM table_name;

then

SELECT setval('"table_name_id_seq"', (SELECT MAX(id) FROM table_name)+1);

Sample:

SELECT setval('configuration.config_shared_property_id_seq', (SELECT MAX(id) FROM "configuration".config_shared_property)+1);