postgresql alter table sequence id starting at a given value

Question

The 'id' from my table 'biblios' didn't autoincrement. It had already data in it and the 'id' go from 112 to 175.

I altered the table to add nextval, doing this:

CREATE SEQUENCE biblios_id_seq
OWNED by biblios.id;
ALTER TABLE biblios
ALTER id
SET DEFAULT nextval('biblios_id_seq'::regclass);

This starts the id at '1'.

How do I make the autoincrement continue at '176' ?

JGH · Accepted Answer · 2019-03-18 19:01:20Z

1

Since the sequence is already created, you can reset it using

SELECT setval('biblios_id_seq', max(id)) FROM biblios;

answered Mar 18, 2019 at 19:01

JGH

18.2k5 gold badges40 silver badges57 bronze badges

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

Comments

Paco Abato · Accepted Answer · 2019-03-18 18:58:56Z

0

Use MINVALUE minvalue:

CREATE SEQUENCE biblios_id_seq
MINVALUE 176
OWNED by biblios.id;
ALTER TABLE biblios
ALTER id
SET DEFAULT nextval('biblios_id_seq'::regclass);

answered Mar 18, 2019 at 18:58

Paco Abato

4,0845 gold badges36 silver badges61 bronze badges