Carson
Reputation: 17751
PostgreSQL, How to re-cast a table column from Integer to Decimal?
I'd like to alter a PostgreSQL column to convert from integer to decimal, setting all integer values to <value>.0. How do I do this?
Upvotes: 1
Views: 942
Answers (1)
Andrew Lazarus
Reputation: 19320
ALTER TABLE my_table_name ALTER some_column TYPE decimal;
Relevant documentation.
Upvotes: 3
Related Questions
- PostgreSQL Convert column from integer to text
- How do I CAST AS DECIMAL in postgresql?
- Alter PostgreSQL column from integer to decimal
- Change type of varchar field to integer: "cannot be cast automatically to type integer"
- How can I assign a data type decimal to a column in Postgresql?
- How to cast int to string in PostgreSQL
- PostgreSQL - casting varchar to int?
- postgres update text column value into integer column
- PostgreSQL: How to convert string with float number into integer?
- PostgreSQL : converting existing double precision column to integer data type