Postgres start table ID from 1000

Question

Before you mark this a duplicate. I found this answer on another thread and having difficulties making it work.

From psql I see my table:

\d people

Table:

Column | Type | Modifiers
---------------+----------------------------------+-----------------------------------------------------------------------
id | integer | not null default nextval('people_id_seq'::regclass)

Code I tried which seems to do nothing...

ALTER SEQUENCE people_id_seq RESTART 1000

How do I make the primary key start from 1000?

try also if this can help [see this][1] [1]: http://stackoverflow.com/questions/12076741/rails-migration-for-id-column-to-start-at-1-000-and-autoincrement-up-from-there — bumbumpaw, Jun 26 '14 at 00:49
"seems to do nothing"? Well, what happens before/after? How do you determine what it does/doesn't do? Show some code. — Craig Ringer, Jun 26 '14 at 02:37

score 7 · Accepted Answer · answered Jun 26 '14 at 00:51

7

The following query would set the sequence value to 999. The next time the sequence is accessed, you would get 1000.

SELECT setval('people_id_seq', 999);

Reference:

Sequence Manipulation Functions on PostgreSQL Manual

answered Jun 26 '14 at 00:51

Joseph B

5,519
1
15
19

score 2 · Answer 2 · answered Jun 26 '14 at 01:25

Why are you declaring your id like that ?

I mean, I would do the following :

create table people( id serial, constraint primaryKeyID primary key(id));

And now if you want to start your sequence from 1000, your alter query will work.

alter sequence people_id_seq restart 1000

Postgres start table ID from 1000

2 Answers2