postgresql

//查询自增序列

SELECT * FROM pg_sequences WHERE sequencename like '%sys_menu%'

设置序列值

ALTER SEQUENCE sys_menu_menu_id_seq2 MINVALUE  20000;

ALTER SEQUENCE sys_menu_menu_id_seq2 RESTART WITH 20000;

和最大值一样

select setval('sys_menu_menu_id_seq2', max(menu_id)) from sys_menu;

修改字段类型

ALTER TABLE sim_library_script
ALTER COLUMN app_type TYPE VARCHAR(255)
USING app_type::VARCHAR(255);