Alter PostgreSQL column from integer to decimal

Question

Thanks to a last minute client request a integer field in our database now needs to be a decimal, to two points.A value of 23 should become 23.00.

Is there a nice way I can convert the table and cast the data across?

I'll freely admit, I haven't done anything like this with PostgreSQL before so please be gentle with me.

s.alem · Accepted Answer · 2016-05-24 07:57:55Z

41

Something like this should work:

alter table t alter column c type decimal(10,2);

Edit:

As @Oli stated in the comments; the first number is the entire length of the number (excluding the point) so the maxval for (10,2) would be 99999999.99

edited May 24, 2016 at 7:57

s.alem

13.2k9 gold badges47 silver badges75 bronze badges

answered Jun 26, 2011 at 17:25

Szymon Lipiński

28.8k17 gold badges81 silver badges82 bronze badges

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

2 Comments

Oli Over a year ago

What does the (10,2) represent? Does it mean it'll accept a value up to 9999999999.99?

Oli Over a year ago

I see now that the first number is the entire length of the number (excluding the point) so the maxval for (10,2) would be 99999999.99

Nikki · Accepted Answer · 2022-08-30 13:00:30Z

0

alter table table_name alter column columname type decimal(16,2);

for converting data type from int to decimal. with precession after decimal point 2 values it will come for example 10.285 then it will be 10.23.or in decimal place we can use numeric also it will work.

answered Aug 30, 2022 at 13:00

Nikki

12 bronze badges

Collectives™ on Stack Overflow

Alter PostgreSQL column from integer to decimal

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related