sql - Postgres start table ID from 1000 -

before mark duplicate. found answer on thread , having difficulties making work.

from psql see table:

\d people 

table:

column       |                   type                |                        modifiers
---------------+----------------------------------+-----------------------------------------------------------------------
id                 |               integer                 |       not null default nextval('people_id_seq'::regclass)

code tried seems nothing...

alter sequence people_id_seq restart 1000 

how make primary key start 1000?

the following query set sequence value 999. next time sequence accessed, 1000.

select setval('people_id_seq', 999); 

reference:

sequence manipulation functions on postgresql manual