How to force sqalchemy float type to real in postgres

Question

When I define a column using sqlalchemy I use the float type with syntax like

from sqlalchemy import Column, Float
new_column_name = Column('new_column_name',Float,nullable=True)

This seems to default to a double in postgres, if I wanted a real, is this done through the precision input, or a different type?

Adrian Klaver · Accepted Answer · 2020-07-16 16:20:06Z

4

From here:

class sqlalchemy.types.REAL(precision=None, asdecimal=False, decimal_return_scale=None)

    Bases: sqlalchemy.types.Float

    The SQL REAL type.

answered Jul 16, 2020 at 16:20

Adrian Klaver

20.4k3 gold badges24 silver badges40 bronze badges

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

1 Comment

Ah, that's clear, sorry to have missed that and thank you!