how to create PostgreSQL 'text' column using SQLModel for FastAPI

Question

I'm using SQLModel for FastAPI. But I don't know how to create 'text' column type using it.

How can I create 'text' column? Thank you for reading it.

from sqlmodel import SQLModel, Field


class BaseModel(SQLModel):
    col_1: str = Field(default='Y')
    col_2: str = Field(default='N')
    col_3: str = Field(default='0')
    col_4: str = Field(default='0')

this is my solution!

from sqlmodel import SQLModel, Field
from sqlalchemy import Column, TEXT


class BaseModel(SQLModel):
    col_5: str = Field(sa_column=Column(TEXT))

You dont need to force it to be TEXT, by default it will make the column VARCHAR which is an alias for TEXT on Postgres. Refer to SQLModel website here: sqlmodel.tiangolo.com/tutorial/create-db-and-table/… — Zaffer
– Zaffer, Commented May 25, 2022 at 13:56

Nikita · Accepted Answer · 2022-04-03 20:16:18Z

4

Try this:

from sqlalchemy.dialects.postgresql import TEXT

from sqlmodel import SQLModel, Field
from sqlalchemy import Column


class BaseModel(SQLModel):
    col_5: str = Field(sa_column=Column(TEXT))

answered Apr 3, 2022 at 20:16

Nikita

4663 silver badges12 bronze badges

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

1 Comment

RoyalBigMack Over a year ago

Don't forget to add sqlalchemy into your requirements.txt

Collectives™ on Stack Overflow

how to create PostgreSQL 'text' column using SQLModel for FastAPI

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related