使用navicat
image.png
勾选序列,避免错误:
cannot drop sequence ghgksj_kzxxxgh_csx_gid_seq because other objects depend on it
DETAIL: default value for column gid of table ghgksj_kzxxxgh_csx depends on sequence ghgksj_kzxxxgh_csx_gid_seq
HINT: Use DROP ... CASCADE to drop the dependent objects too.