CODE EXAMPLE FOR SQL

postgres change column type string to integer

ALTER TABLE the_table ALTER COLUMN col_name TYPE integer USING (col_name::integer);