PGSQL序列未定义和建立ORACLE的序列触发器

POSTGRESQL

CREATE SEQUENCE seq_table
INCREMENT 1
MINVALUE 1
MAXVALUE 9223372036854775807
START 1
CACHE 10;
ALTER TABLE seq_table
OWNER TO postgres;

table换成你自己的表名
schema换成自己的模式名

PK【主键】
nextval('schema.seq_table'::regclass)
或者用命令插入
alter table xxx  alter column xxx set default nextval('schema.seq_table'::regclass)
pxbj 
currval('schema.seq_table'::regclass)
同样也可用命令
alter table xxx alter column xxx  set default currval('schema.seq_table'::regclass);

执行---->>>>

Oracle

—序列 USER->用户 TABLE->表名

DROP SEQUENCE "USER"."SEQ_TABLE";
CREATE SEQUENCE "USER"."SEQ_TABLE" MINVALUE 1 MAXVALUE 99999999999 INCREMENT BY 1 CACHE 10;

—触发器

CREATE TRIGGER "USER"."SEQ_TABLE" BEFORE INSERT ON "USER"."TABLE" REFERENCING OLD AS "OLD" NEW AS "NEW" FOR EACH ROW WHEN (new.sid is null) 
begin
select SEQ_TABLE.nextval into :new.sid from dual;
if :new.PXBJ is null then
select SEQ_TABLE.CURRVAL into :new.PXBJ from dual;
end if;
end