How to copy a Postgresql varchar column to an integer column

Question

I have a postgresql table named baseballs with a column named quantity of type = varchar and would like to populate the quantity_integer column with type = integer

How would I write a SQL statement?

Answer 1

update baseballs set quantity_integer = quantity::int;