Answers for "postgresql set sequence value"

postgresql update sequence next value

ALTER SEQUENCE seq_name RESTART WITH 22;

Posted by: Guest on April-07-2021

check current sequence value postgres

SELECT last_value FROM sequence_name;

Posted by: Guest on April-17-2020

update postgres sequence to max

SELECT setval('table_id_seq', (SELECT MAX(id) FROM table)+1);

Posted by: Guest on February-25-2021

Code answers related to "postgresql set sequence value"