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

52 votes265 views6 answers
Rename column sql
SQL
0 vote130 views2 answers
While mysql
SQL
0 vote97 views1 answer
Oracle sql count occurrences of value in column
SQL
1 vote100 views1 answer
Rename table column name in mysql
SQL
1 vote101 views1 answer
Mysql show current queries
SQL
0 vote111 views2 answers
Dbms interview questions
SQL
5 votes67 views1 answer
Mongodb vs
SQL
3 votes112 views2 answers
Sqlite show table definition
SQL
0 vote109 views1 answer
Query to generate query to drop primary keys or foreign key in ms sql server
SQL
0 vote110 views1 answer
Get only one row in mysql
SQL