Posted By

Tagged

Viewed 577 times

Favorited by 0 user(s)

/ Published in: SQL

reset id sequence from postgres table

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

WITH mx AS ( SELECT MAX(id) AS id FROM sch.mytable)
SELECT SETVAL('sch.mytable_id_seq', mx.id) AS curseq
FROM mx;

Comment:

You need to login to post a comment.