PostgreSQL - 시퀀스 생성
문법 CREATE SEQUENCE [ IF NOT EXISTS ] sequence_name [ AS { SMALLINT | INTEGER | BIGINT } ] [ INCREMENT [ BY ] increment ] [ MINVALUE minvalue | NO MINVALUE ] [ MAXVALUE maxvalue | NO MAXVALUE ] [ START [ WITH ] start ] [ CACHE cache ] [ [ NO ] CYCLE ] [ OWNED BY { table_name.column_name | NONE } ]예시 CREATE SEQUENCE s1.seq_emp AS integer INCREMENT 1 MINVALUE 1 MAXVALUE 999999 START 1 CACHE 1 OWENE..
2022. 4. 22. 23:06