Postgres set auto increment counter to a fixed value

Question

I want to set primary value to start with 1000 in postgres.

i know a command in mysql

ALTER TABLE tablename AUTO_INCREMENT = 1000

how to write the above mysql command in postgres ?

score 1 · Accepted Answer · 2021-09-07 07:48:44Z

1

identity (and the somewhat outdated serial) columns are based on sequences.

You can set the sequence associated with such a column using setval()

select setval(pg_get_serial_sequence('table_name', 'column_name'), 1000);

answered Sep 7, 2021 at 7:45

user330315

Sign up to request clarification or add additional context in comments.

2 Comments

serial is outdated? what is alternate to use?

@Curious: as I wrote: identity columns. See here for details