(1)create sequence seq_user_id increment 1 start 20000;

(2)alter table userinfos alter column user_id set default nextval('seq_user_id');

(3)create table userinfos
(
 user_id int8  default nextval('seq_user_id') primary key
 user_name varchar(40)
)




|----------------------------------------------------------------------------------------|
                           版权声明  版权所有 @zhyiwww
            引用请注明来源 http://www.blogjava.net/zhyiwww   
|----------------------------------------------------------------------------------------|