Postgresql reset auto increment

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

Source: stackoverflow.com

Postgresql update auto_increment value

ALTER SEQUENCE product_id_seq RESTART WITH 1453

Source: stackoverflow.com

Postgresql reset auto_increment index

-- Change the starting value of the sequence

ALTER SEQUENCE project_id_seq RESTART 3000;

-- Same but dynamic :

SELECT SETVAL('project_id_seq', (SELECT MAX(id) + 1 FROM project));

Source: stackoverflow.com

Similar codes

1 vote212 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
4 votes190 views3 answers
Mysql varchar length
SQL
0 vote282 views1 answer
Best sql collation
SQL
4 votes204 views2 answers
Oracle unlock user
SQL
0 vote208 views1 answer
How to set all the min and sec data to zero in sql server
SQL
5 votes248 views2 answers
Oracle show procedures
SQL
1 vote209 views1 answer
How to group by month using sql server
SQL
0 vote277 views1 answer
Insert into table with only identity column
SQL
0 vote175 views1 answer
Postgresql add leading zeros
SQL
0 vote237 views1 answer
Show tables in cassandra cql
SQL