Table ID with auto increment and start from
hey everyone, I have a table where the ID is an int8 with "isIdentidy" to auto increment. Is there a way to change the "start from" ? My intention is to start the ID from 1000 for example.
GYes it can be done. This would be a Postgres question and there are lots of examples out there. Just google or ask the SQL AI it might have the answer. I would have to google as I don't remember it off the top of my head.
Mthis worked for me !
select pg_get_serial_sequence('public.project', 'id');
-> it will return the sequence's name
ALTER SEQUENCE public.project_id_seq RESTART 123456;
select pg_get_serial_sequence('public.project', 'id');
-> it will return the sequence's name
ALTER SEQUENCE public.project_id_seq RESTART 123456;
