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 vote166 views2 answers
How to tun mysql on ubunto
SQL
5 votes218 views1 answer
How to get all table names in sql query
SQL
0 vote213 views1 answer
How to create notes in mysql
SQL
0 vote173 views1 answer
Mysql a from on this page has
SQL
0 vote159 views1 answer
Postgres call view
SQL
3 votes179 views1 answer
Postgres select max value
SQL
0 vote164 views1 answer
Sql cursor example multiple columns
SQL
0 vote178 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL
1 vote178 views1 answer
How to use db.execute
SQL
1 vote172 views3 answers
Epoch to datetime
SQL