CODE EXAMPLE FOR SQL

postgres restart id

-- if you dont mind losing the data, do the following
TRUNCATE TABLE someTable RESTART IDENTITY;