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)

Community · Accepted Answer · 2017-05-23 12:06:23Z

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$$;

CommunityBot

11 silver badge

answered Apr 21, 2015 at 23:01

668k159 gold badges1.2k silver badges1.3k bronze badges

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

2 Comments

That's using postgres. I'd ideally like something that works with SQLAlchemy/Alembic

As a temporary solution I am manually running this and it works