Original column
Column Type Modifiers
model | character varying(50) | default NULL::character varying
Required Column
Model integer
=========
ALTER TABLE device ALTER COLUMN model TYPE integer USING (model::integer);
getting below error
ERROR: default for column "model" cannot be cast automatically to type integer