Postgresql reset sequence

ALTER SEQUENCE <tablename>_<id>_seq RESTART WITH 1

Source: stackoverflow.com

Reset id sequence postgres

alter sequence <tableName>_id_seq restart with 1;
For an instance, we have a table named "groups" and we need to reset the id sequence with 1. 
alter sequence groups_id_seq restart with 1;

Similar codes

0 vote125 views2 answers
Sql last updated
SQL
0 vote129 views1 answer
C# add a textbox in mysql select
SQL
2 votes136 views2 answers
Spring where to put the data sql
SQL
6 votes124 views1 answer
Phpmyadmin reset root password
SQL
4 votes134 views3 answers
How to describe a table in sqlite3
SQL
8 votes139 views2 answers
Safe update mode in mysql
SQL
3 votes138 views1 answer
Fk in insert mysql
SQL
0 vote142 views1 answer
Drop view in mysql
SQL
5 votes130 views1 answer
How to get all dates in a month in oracle
SQL
0 vote128 views1 answer
If null don't update
SQL