Answer: How to use an existing sqlalchemy Enum in an Alembic migration (Postgres)

answer re: How to use an existing sqlalchemy Enum in an Alembic migration (Postgres)

Feb 11 '21

32

There are two parts to make this happen with Postgres.

1. Specify create_type=False
2. Use sqlalchemy.dialects.postgresql.ENUM (not sqlalchemy.Enum)

Eg:

from sqlalchemy.dialects import postgresql

sa.Column('my_column', postgresql.ENUM(name='my_enum', create_type=False))

Open Full Answer