ALTER SEQUENCE name [ INCREMENT [ BY ] increment ] [ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO MAXVALUE ] [ RESTART [ WITH ] start ] [ CACHE cache ] [ [ NO ] CYCLE ] [ OWNED BY { table.column | NONE } ] ALTER SEQUENCE name RENAME TO new_name ALTER SEQUENCE name SET SCHEMA new_schema
CREATE [ TEMPORARY | TEMP ] SEQUENCE name [ INCREMENT [ BY ] increment ] [ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO MAXVALUE ] [ START [ WITH ] start ] [ CACHE cache ] [ [ NO ] CYCLE ] [ OWNED BY { table.column | NONE } ] 创建
CREATE TABLE user_base ( id serial NOT NULL, username character varying(100) NOT NULL, "password" character varying(500) NOT NULL, isenabled boolean DEFAULT false, CONSTRAINT user_base_pkey PRIMARY KEY (id), CONSTRAINT user_base_username_key UNIQUE (username) ) WITH (OIDS=FALSE);
[ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO MAXVALUE ]
[ RESTART [ WITH ] start ] [ CACHE cache ] [ [ NO ] CYCLE ]
[ OWNED BY { table.column | NONE } ]
ALTER SEQUENCE name RENAME TO new_name
ALTER SEQUENCE name SET SCHEMA new_schema
[ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO MAXVALUE ]
[ START [ WITH ] start ] [ CACHE cache ] [ [ NO ] CYCLE ]
[ OWNED BY { table.column | NONE } ]
创建
不过好像只能一个个增长,还没有找到设置方法
(
id serial NOT NULL,
username character varying(100) NOT NULL,
"password" character varying(500) NOT NULL,
isenabled boolean DEFAULT false,
CONSTRAINT user_base_pkey PRIMARY KEY (id),
CONSTRAINT user_base_username_key UNIQUE (username)
)
WITH (OIDS=FALSE);