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 vote116 views1 answer
USING THE NOT CONDITION IN SQL
SQL
10 votes103 views1 answer
Oracle view dependencies
SQL
0 vote111 views1 answer
Postgresql check total storage
SQL
4 votes99 views1 answer
Check database name postgresql
SQL
14 votes108 views6 answers
Auto_increment mysql
SQL
3 votes100 views1 answer
Oracle get trigger ddl
SQL
0 vote92 views1 answer
Postgresql certain first 4 characters in string
SQL
4 votes102 views2 answers
Dbms_scheduler stop job
SQL
0 vote115 views1 answer
How to check which table has data in mysql
SQL
104 votes276 views2 answers
Like in mysql
SQL