数据库

Postgresql sequence nextval in schema

问题:


解决:


// 创建SEQUENCE
CREATE SEQUENCE ita_db.SEQ_ABC
	INCREMENT BY 1
	MINVALUE 1
	MAXVALUE 9999999999
	START WITH 1
	NO CYCLE
	CACHE 1;

// 使用的例子
CREATE TABLE ita_db.TABLE_TEST (
	TEST_USER_ID BIGINT DEFAULT nextval ('"ita_db".SEQ_ABC')  NOT NULL,
	CRE_USER_ID VARCHAR(20)  NOT NULL,
	CRE_TMSTMP TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
	UPD_USER_ID VARCHAR(20)  NOT NULL,
	UPD_TMSTMP TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
	, CONSTRAINT DOMESTIC_ACCOM_CODE_MST_PK PRIMARY KEY (
		TEST_USER_ID
	)
);