ALTER TABLE
customers
ALTER
COLUMN age TYPE NUMERIC (10,0) USING age::NUMERIC;
COLUMN age TYPE NUMERIC (10,0) USING CAST(age AS NUMERIC);