ALTER TABLE the_table ALTER COLUMN col_name TYPE integer USING (col_name::integer);
ALTER TABLE the_table ALTER COLUMN col_name TYPE integer USING (trim(col_name)::integer);
Change type of varchar field to integer: “cannot be cast automatically to type integer”
最新推荐文章于 2022-07-11 08:47:17 发布