Reset Sequence using PostgreSQL

Posted on August 24, 2011 by admin

1	SELECT setval('YOUR_SEQUENCE_NAME', (SELECT MAX(id) FROM YOUR_TABLE_NAME));

This entry was posted in Database, PostgreSQL. Bookmark the permalink.