Answers for "postgres set sequence to max id"

postgres set sequence value to max id

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

Posted by: Guest on January-19-2021

update postgres sequence to max

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

Posted by: Guest on February-25-2021

setval max id postgresql sequence

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

Posted by: Guest on June-16-2021

Code answers related to "postgres set sequence to max id"