Change Heroku Postgres database column type while retaining data

Question

I've created a Heroku Postgres database, with one of the columns being db.Integer - storing integers. However, I realize that I should actually store floating point numbers instead - i.e., db.Float.

Can I change the type of a PostgreSQL database column - after it has been created with data?

wowkin2 · Accepted Answer · 2020-09-30 15:33:11Z

2

Yes, you can. Use following query to do that:

ALTER TABLE $TABLE_NAME ALTER COLUMN $COLUMN_NAME TYPE <float type, e.g. float(64)>;

edited Sep 30, 2020 at 15:33

wowkin2

6,4355 gold badges29 silver badges76 bronze badges

answered Sep 30, 2020 at 14:05

RangerRanger

2,5132 gold badges20 silver badges38 bronze badges

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

Collectives™ on Stack Overflow

Change Heroku Postgres database column type while retaining data

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related