ALTER TABLE assets ALTER COLUMN asset_no TYPE INT USING asset_no::integer; ALTER TABLE assets ALTER COLUMN location TYPE VARCHAR, ALTER COLUMN description TYPE VARCHAR; alter table temp_runner_orders_v2 alter column distancefixed type float USING distancefixed::double precision; -- alter table temp_runner_orders_v2 alter column durationfixed type int USING durationfixed ::integer ; -- ALTER TABLE temp_runner_orders_v2 ALTER COLUMN pickuptimefixed TYPE DATE USING to_date(pickuptimefixed , 'YYYY-MM-DD');