To set the autoincrement number in PostgreSQL, use the following query:

ALTER SEQUENCE "users_id_seq" RESTART WITH 1000;

#database #postgresql