psql reset id sequence code example
Example 1: tsql reseed identity
USE AdventureWorks2012;
GO
DBCC CHECKIDENT ('Person.AddressType', RESEED, 10);
GO
Example 2: reset identity column in sql server
DBCC CHECKIDENT ('YourTableName', RESEED, 1)
Example 3: 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;