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

15 votes324 views3 answers
Mysql update add to existing value
SQL
1 vote300 views1 answer
Oracle undo usage per session
SQL
0 vote294 views1 answer
How much space does sql server take per row
SQL
3 votes283 views2 answers
Oracle apex view logs
SQL
4 votes286 views2 answers
Mysql how to change default charset
SQL
0 vote291 views1 answer
Monthly Birthday SQL Query
SQL
0 vote309 views1 answer
How to find total working hour in sql
SQL
0 vote316 views1 answer
Oracle decode
SQL
1 vote275 views2 answers
Oracle replace
SQL
1 vote294 views1 answer
Mysql data from file
SQL