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 vote189 views1 answer
Sqlalchemy orm duplicate
SQL
0 vote174 views1 answer
Mysql equivalent decode oracle
SQL
1 vote151 views1 answer
How to fetch alternate records from two tables
SQL
1 vote170 views1 answer
Encrypt password postgresql
SQL
1 vote138 views2 answers
Install mysqldump ubuntu
SQL
0 vote170 views2 answers
Nested query
SQL
0 vote149 views1 answer
Mysql Like(searching in the string)
SQL
0 vote157 views1 answer
Oracle to_number
SQL
2 votes168 views1 answer
Mariadb json select
SQL
0 vote142 views1 answer
Search from comma separated values in sql server
SQL