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 vote191 views1 answer
The local psql command could not be located
SQL
0 vote201 views1 answer
Doesn't have default value mysql
SQL
1 vote227 views1 answer
Oracle sequence last_number
SQL
2 votes228 views1 answer
Error Code: 1055. Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column \\ which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote269 views1 answer
TSQL Find csv file in folder
SQL
1 vote199 views1 answer
Hexadec to sql REDSHIFT
SQL
12 votes193 views2 answers
Delete all data in neo4j
SQL
0 vote256 views1 answer
How to find unique element in sql
SQL
0 vote201 views1 answer
Sql dmv to capture updates
SQL
0 vote287 views1 answer
SHOW RESULT WITHOUT ROUND IN SQL
SQL