postgresql字符串类型转为int,bigint类型

ALTER TABLE position ALTER COLUMN f4
SET DATA TYPE BIGINT USING f4 :: BIGINT

其中positon为表明,f4为列名

转载自:https://blog.csdn.net/A873054267/article/details/83268885

You may also like...

退出移动版