How to deal with Postgres Enum columns? #31
Description
First Check
- I added a very descriptive title to this issue.
- I used the GitHub search to find a similar issue and didn't find it.
- I searched the SQLModel documentation, with the integrated search.
- I already searched in Google "How to X in SQLModel" and didn't find any information.
- I already read and followed all the tutorial in the docs and didn't find an answer.
- I already checked if it is not related to SQLModel but to Pydantic.
- I already checked if it is not related to SQLModel but to SQLAlchemy.
Commit to Help
- I commit to help with one of those options 👆
Example Code
from typing import List, Optional
from enum import Enum
import sqlalchemy as sa
import sqlmodel
class Status(str, Enum):
active = "active"
banned = "banned"
status_enum = postgresql.ENUM("active", "banned", "c", name="status_enum")
class User(sqlmodel.SQLModel, table=True):
__tablename__ = "auth_user"
id: int = sqlmodel.Field(primary_key=True)
status: Status = sqlmodel.Field(status_enum)
password: strDescription
How to use Postgres Enums together with SQLModel?
Operating System
Linux
Operating System Details
No response
SQLModel Version
0.0.3
Python Version
3.8.11
Additional Context
No response