1-- if you dont mind losing the data, do the following
2TRUNCATE TABLE someTable RESTART IDENTITY;
1-- Change the starting value of the sequence
2
3ALTER SEQUENCE project_id_seq RESTART 3000;
4
5-- Same but dynamic :
6
7SELECT SETVAL('project_id_seq', (SELECT MAX(id) + 1 FROM project));