postgresql reset identity code example

Example 1: postgresql reset auto increment

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

Example 2: postgresql reset serial counter after deleting content

ALTER SEQUENCE product_id_seq RESTART WITH 1453