How to increment id by X in Postgres using SQLAlchemy?

Question

How can I increment this id, by 4 instead of 1 as it does by default using SQLAlchemy + Postgres? I'm using SQLAlchemy, Postgres, and Alembic.

id = Column(BigInteger, primary_key=True)

score 1 · Accepted Answer · edited May 23 '17 at 12:06

1

Get the name of the underlying SEQUENCE for your serial column and change its increment:

SELECT pg_get_serial_sequence('tbl', 'id');

Then:

ALTER SEQUENCE tbl_id_seq INCREMENT 4;  -- replace with actual name

Or with a single integrated DO statement:

DO
$$BEGIN
EXECUTE format('ALTER SEQUENCE %s INCREMENT 4'
              , pg_get_serial_sequence('tbl', 'id');
END$$;

edited May 23 '17 at 12:06

Community

answered Apr 21 '15 at 23:01

That's using postgres. I'd ideally like something that works with SQLAlchemy/Alembic – mergesort Apr 21 '15 at 23:11
As a temporary solution I am manually running this and it works – mergesort Apr 23 '15 at 16:26

1 Answers1