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

0 vote355 views1 answer
Sql server create constraint
SQL
7 votes395 views2 answers
How to create index mysql
SQL
19 votes355 views5 answers
Date between in mysql
SQL
4 votes335 views1 answer
What are the data types in sql
SQL
0 vote340 views1 answer
Use where instead of join
SQL
8 votes363 views1 answer
How to check mysql version in xampp
SQL
0 vote358 views2 answers
.... ERROR! The server quit without updating PID file mysql centos
SQL
4 votes360 views2 answers
Tsql utf to local time
SQL
0 vote365 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL
8 votes381 views4 answers
Postgresql server restart
SQL